org.hibernate.exception.SQLGrammarException: could not extract ResultSet

Atlassian JIRA | Daniel Rohan [Atlassian] | 2 years ago
  1. 0

    {noformat}2015-06-05 19:14:17,101 WARN [pull-request-rescoping:thread-1] o.h.e.jdbc.spi.SqlExceptionHelper SQL Error: 1795, SQLState: 42000 2015-06-05 19:14:17,102 ERROR [pull-request-rescoping:thread-1] o.h.e.jdbc.spi.SqlExceptionHelper ORA-01795: maximum number of expressions in a list is 1000 2015-06-05 19:14:17,109 ERROR [pull-request-rescoping:thread-1] c.a.s.i.c.HazelcastBucketedExecutor Attempt 1 of 1 at processing bucket 'pull-request-rescoping@42' for executor 'pull-request-rescoping' failed: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.loader.Loader.getResultSet(Loader.java:2066) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.loader.Loader.doQuery(Loader.java:910) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.loader.Loader.doList(Loader.java:2554) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.loader.Loader.doList(Loader.java:2540) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.loader.Loader.list(Loader.java:2365) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:126) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1682) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at com.atlassian.stash.internal.AbstractHibernateDao.getByIds(AbstractHibernateDao.java:95) ~[stash-dao-impl-3.9.2.jar:na] at com.atlassian.stash.internal.pull.HibernateRescopeRequestDao.getByIds(HibernateRescopeRequestDao.java:56) ~[stash-dao-impl-3.9.2.jar:na] at com.atlassian.stash.internal.pull.rescope.PullRequestRescopeBucketProcessor$2.doInTransaction(PullRequestRescopeBucketProcessor.java:134) ~[stash-service-impl-3.9.2.jar:na] at com.atlassian.stash.internal.pull.rescope.PullRequestRescopeBucketProcessor$2.doInTransaction(PullRequestRescopeBucketProcessor.java:131) ~[stash-service-impl-3.9.2.jar:na] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133) ~[spring-tx-4.1.6.RELEASE.jar:4.1.6.RELEASE] at com.atlassian.stash.internal.pull.rescope.PullRequestRescopeBucketProcessor.process(PullRequestRescopeBucketProcessor.java:131) ~[stash-service-impl-3.9.2.jar:na] at com.atlassian.stash.internal.concurrent.HazelcastBucketedExecutor$BucketProcessingBootstrapper.run(HazelcastBucketedExecutor.java:130) ~[stash-service-impl-3.9.2.jar:na] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_40] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_40] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [na:1.8.0_40] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [na:1.8.0_40] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_40] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_40] ... 21 frames trimmed Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:172) ~[bonecp-spring-0.7.1.RELEASE.jar:0.7.1.RELEASE] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] ... 26 common frames omitted{noformat}

    Atlassian JIRA | 2 years ago | Daniel Rohan [Atlassian]
    org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  2. 0

    {noformat}2015-06-05 19:14:17,101 WARN [pull-request-rescoping:thread-1] o.h.e.jdbc.spi.SqlExceptionHelper SQL Error: 1795, SQLState: 42000 2015-06-05 19:14:17,102 ERROR [pull-request-rescoping:thread-1] o.h.e.jdbc.spi.SqlExceptionHelper ORA-01795: maximum number of expressions in a list is 1000 2015-06-05 19:14:17,109 ERROR [pull-request-rescoping:thread-1] c.a.s.i.c.HazelcastBucketedExecutor Attempt 1 of 1 at processing bucket 'pull-request-rescoping@42' for executor 'pull-request-rescoping' failed: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.loader.Loader.getResultSet(Loader.java:2066) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.loader.Loader.doQuery(Loader.java:910) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.loader.Loader.doList(Loader.java:2554) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.loader.Loader.doList(Loader.java:2540) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.loader.Loader.list(Loader.java:2365) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:126) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1682) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] at com.atlassian.stash.internal.AbstractHibernateDao.getByIds(AbstractHibernateDao.java:95) ~[stash-dao-impl-3.9.2.jar:na] at com.atlassian.stash.internal.pull.HibernateRescopeRequestDao.getByIds(HibernateRescopeRequestDao.java:56) ~[stash-dao-impl-3.9.2.jar:na] at com.atlassian.stash.internal.pull.rescope.PullRequestRescopeBucketProcessor$2.doInTransaction(PullRequestRescopeBucketProcessor.java:134) ~[stash-service-impl-3.9.2.jar:na] at com.atlassian.stash.internal.pull.rescope.PullRequestRescopeBucketProcessor$2.doInTransaction(PullRequestRescopeBucketProcessor.java:131) ~[stash-service-impl-3.9.2.jar:na] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133) ~[spring-tx-4.1.6.RELEASE.jar:4.1.6.RELEASE] at com.atlassian.stash.internal.pull.rescope.PullRequestRescopeBucketProcessor.process(PullRequestRescopeBucketProcessor.java:131) ~[stash-service-impl-3.9.2.jar:na] at com.atlassian.stash.internal.concurrent.HazelcastBucketedExecutor$BucketProcessingBootstrapper.run(HazelcastBucketedExecutor.java:130) ~[stash-service-impl-3.9.2.jar:na] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_40] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_40] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [na:1.8.0_40] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [na:1.8.0_40] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_40] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_40] ... 21 frames trimmed Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) ~[ojdbc6-11.2.0.2.0.jar:11.2.0.2.0] at com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:172) ~[bonecp-spring-0.7.1.RELEASE.jar:0.7.1.RELEASE] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82) ~[hibernate-core-4.3.8.Final.jar:4.3.8.Final] ... 26 common frames omitted{noformat}

    Atlassian JIRA | 2 years ago | Daniel Rohan [Atlassian]
    org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Joining using Criteria query using Composite Key

    Stack Overflow | 2 years ago | Sumit Ghosh
    org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  5. 0

    How to sort by CLOB column with Hibernate / DB2

    Stack Overflow | 2 years ago
    org.hibernate.exception.SQLGrammarException: could not extract ResultSet

  1. Kawada 22 times, last 7 months ago
2 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.hibernate.exception.SQLGrammarException

    could not extract ResultSet

    at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert()
  2. Hibernate
    CriteriaImpl.list
    1. org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    2. org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    3. org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    4. org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    5. org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    6. org.hibernate.loader.Loader.getResultSet(Loader.java:2066)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    7. org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    8. org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    9. org.hibernate.loader.Loader.doQuery(Loader.java:910)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    10. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    11. org.hibernate.loader.Loader.doList(Loader.java:2554)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    12. org.hibernate.loader.Loader.doList(Loader.java:2540)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    13. org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    14. org.hibernate.loader.Loader.list(Loader.java:2365)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    15. org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:126)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    16. org.hibernate.internal.SessionImpl.list(SessionImpl.java:1682)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    17. org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    17 frames
  3. com.atlassian.stash
    PullRequestRescopeBucketProcessor$2.doInTransaction
    1. com.atlassian.stash.internal.AbstractHibernateDao.getByIds(AbstractHibernateDao.java:95)[stash-dao-impl-3.9.2.jar:na]
    2. com.atlassian.stash.internal.pull.HibernateRescopeRequestDao.getByIds(HibernateRescopeRequestDao.java:56)[stash-dao-impl-3.9.2.jar:na]
    3. com.atlassian.stash.internal.pull.rescope.PullRequestRescopeBucketProcessor$2.doInTransaction(PullRequestRescopeBucketProcessor.java:134)[stash-service-impl-3.9.2.jar:na]
    4. com.atlassian.stash.internal.pull.rescope.PullRequestRescopeBucketProcessor$2.doInTransaction(PullRequestRescopeBucketProcessor.java:131)[stash-service-impl-3.9.2.jar:na]
    4 frames
  4. Spring Tx
    TransactionTemplate.execute
    1. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)[spring-tx-4.1.6.RELEASE.jar:4.1.6.RELEASE]
    1 frame
  5. com.atlassian.stash
    HazelcastBucketedExecutor$BucketProcessingBootstrapper.run
    1. com.atlassian.stash.internal.pull.rescope.PullRequestRescopeBucketProcessor.process(PullRequestRescopeBucketProcessor.java:131)[stash-service-impl-3.9.2.jar:na]
    2. com.atlassian.stash.internal.concurrent.HazelcastBucketedExecutor$BucketProcessingBootstrapper.run(HazelcastBucketedExecutor.java:130)[stash-service-impl-3.9.2.jar:na]
    2 frames
  6. Java RT
    Thread.run
    1. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)[na:1.8.0_40]
    2. java.util.concurrent.FutureTask.run(FutureTask.java:266)[na:1.8.0_40]
    3. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)[na:1.8.0_40]
    4. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)[na:1.8.0_40]
    5. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)[na:1.8.0_40]
    6. java.lang.Thread.run(Thread.java:745)[na:1.8.0_40]
    6 frames