API tools faq
paste
Advertisement
Guest User

Oracle - missing statement

a guest
Sep 25th, 2015
25
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.74 KB | None | 0 0
raw download clone embed print report
  1. javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  2. at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
  3. at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
  4. at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:277)
  5. at org.hibernate.ejb.criteria.CriteriaQueryCompiler$3.getResultList(CriteriaQueryCompiler.java:254)
  6. at org.jbpm.services.task.persistence.TaskQueryCriteriaUtil.createQueryAndCallApplyMetaCriteriaAndGetResult(TaskQueryCriteriaUtil.java:576)
  7. at org.jbpm.services.task.persistence.TaskQueryCriteriaUtil.doCriteriaQuery(TaskQueryCriteriaUtil.java:221)
  8. at org.jbpm.services.task.persistence.JPATaskPersistenceContext.doTaskSummaryCriteriaQuery(JPATaskPersistenceContext.java:489)
  9. at org.jbpm.services.task.impl.TaskQueryServiceImpl.query(TaskQueryServiceImpl.java:633)
  10. at org.jbpm.services.task.commands.TaskQueryWhereCommand.execute(TaskQueryWhereCommand.java:58)
  11. at org.jbpm.services.task.commands.TaskQueryWhereCommand.execute(TaskQueryWhereCommand.java:29)
  12. at org.jbpm.services.task.commands.TaskCommandExecutorImpl$SelfExecutionCommandService.execute(TaskCommandExecutorImpl.java:65)
  13. at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41)
  14. at org.jbpm.services.task.persistence.TaskTransactionInterceptor.execute(TaskTransactionInterceptor.java:69)
  15. at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41)
  16. at org.drools.persistence.jta.TransactionLockInterceptor.execute(TransactionLockInterceptor.java:73)
  17. at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41)
  18. at org.drools.persistence.jpa.OptimisticLockRetryInterceptor.execute(OptimisticLockRetryInterceptor.java:82)
  19. at org.jbpm.services.task.commands.TaskCommandExecutorImpl.execute(TaskCommandExecutorImpl.java:40)
  20. at org.jbpm.services.task.impl.TaskQueryBuilderImpl$1.getResultList(TaskQueryBuilderImpl.java:324)
  21. at org.jbpm.query.QueryBuilderCoverageTestUtil.queryBuilderCoverageTest(QueryBuilderCoverageTestUtil.java:151)
  22. at org.jbpm.services.task.query.TaskQueryBuilderCoverageTest.taskQueryBuilderCoverageTest(TaskQueryBuilderCoverageTest.java:124)
  23. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  24. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  25. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  26. at java.lang.reflect.Method.invoke(Method.java:606)
  27. at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
  28. at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
  29. at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
  30. at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
  31. at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
  32. at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271)
  33. at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70)
  34. at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
  35. at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
  36. at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
  37. at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
  38. at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
  39. at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
  40. at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
  41. at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
  42. at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
  43. at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:264)
  44. at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:153)
  45. at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:124)
  46. at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)
  47. at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
  48. at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)
  49. Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  50. at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82)
  51. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
  52. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)
  53. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
  54. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:88)
  55. at org.hibernate.loader.Loader.getResultSet(Loader.java:2062)
  56. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1859)
  57. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)
  58. at org.hibernate.loader.Loader.doQuery(Loader.java:906)
  59. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)
  60. at org.hibernate.loader.Loader.doList(Loader.java:2550)
  61. at org.hibernate.loader.Loader.doList(Loader.java:2536)
  62. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2366)
  63. at org.hibernate.loader.Loader.list(Loader.java:2361)
  64. at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495)
  65. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357)
  66. at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:198)
  67. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1230)
  68. at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
  69. at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:268)
  70. ... 44 more
  71. Caused by: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  72.  
  73. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
  74. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
  75. at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
  76. at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
  77. at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
  78. at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
  79. at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
  80. at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
  81. at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774)
  82. at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925)
  83. at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)
  84. at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
  85. at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)
  86. at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)
  87. at bitronix.tm.resource.jdbc.JdbcUncachedPreparedStatementHandle.executeQuery(JdbcUncachedPreparedStatementHandle.java:81)
  88. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  89. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  90. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  91. at java.lang.reflect.Method.invoke(Method.java:606)
  92. at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
  93. at com.sun.proxy.$Proxy31.executeQuery(Unknown Source)
  94. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
  95. ... 59 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!