jBPM Oracle Exception
akula.pratap Oct 17, 2005 6:04 AMHello All,
I am getting the following exception when I am trying to fetch task list for a given user. When I debugged it, I found that in the query's where clause isCancelled_ flag is compared with 'False'. Is it because of this the error had occured. Since hibernate is being implemented in jBPM, guess it should take care of this...
4:56:28,968 WARN [PARSER] *** WARNING: Keyword 'end' is being intepreted as an identifier due to: expecting IDENT, found 'end'
14:56:29,187 WARN [JDBCExceptionReporter] SQL Error: 904, SQLState: 42000
14:56:29,187 ERROR [JDBCExceptionReporter] ORA-00904: "FALSE": invalid identifier
14:56:29,187 ERROR [TaskMgmtSession] org.hibernate.exception.SQLGrammarException: could not execute query
14:58:04,531 INFO [STDOUT] java.lang.RuntimeException: couldn't get task instances list for actor 'Supervisor'
14:58:04,531 INFO [STDOUT] at org.jbpm.db.TaskMgmtSession.findTaskInstances(TaskMgmtSession.java:38)
14:58:04,531 INFO [STDOUT] at com.tcs.jbpm.workflow.JbpmInterface.fetchTaskInstances(JbpmInterface.java:178)
14:58:04,531 INFO [STDOUT] at com.tcs.jbpmPoc.workflow.WorkflowAdpater.fetchTasks(WorkflowAdpater.java:35)
14:58:04,531 INFO [STDOUT] at com.tcs.jbpmPoc.ejb.LeaveTestBeanImpl.getWorkList(LeaveTestBeanImpl.java:82)
14:58:04,531 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
14:58:04,546 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
14:58:04,546 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
14:58:04,546 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
14:58:04,546 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
14:58:04,546 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
14:58:04,546 INFO [STDOUT] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
14:58:04,546 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
14:58:04,546 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)
14:58:04,562 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)
14:58:04,562 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:111)
14:58:04,562 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
14:58:04,562 INFO [STDOUT] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
14:58:04,562 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
14:58:04,562 INFO [STDOUT] at org.jboss.ejb.Container.invoke(Container.java:709)
14:58:04,562 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
14:58:04,562 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
14:58:04,562 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
14:58:04,562 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
14:58:04,562 INFO [STDOUT] at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
14:58:04,593 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62)
14:58:04,593 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54)
14:58:04,593 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:82)
14:58:04,593 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:197)
14:58:04,593 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
14:58:04,593 INFO [STDOUT] at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:360)
14:58:04,593 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
14:58:04,593 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
14:58:04,593 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
14:58:04,609 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
14:58:04,609 INFO [STDOUT] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
14:58:04,609 INFO [STDOUT] at sun.rmi.transport.Transport$1.run(Transport.java:148)
14:58:04,609 INFO [STDOUT] at java.security.AccessController.doPrivileged(Native Method)
14:58:04,609 INFO [STDOUT] at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
14:58:04,609 INFO [STDOUT] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
14:58:04,609 INFO [STDOUT] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
14:58:04,609 INFO [STDOUT] at java.lang.Thread.run(Thread.java:534)
14:58:04,609 INFO [STDOUT] Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
14:58:04,609 INFO [STDOUT] at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70)
14:58:04,609 INFO [STDOUT] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
14:58:04,609 INFO [STDOUT] at org.hibernate.loader.Loader.doList(Loader.java:1596)
14:58:04,609 INFO [STDOUT] at org.hibernate.loader.Loader.list(Loader.java:1577)
14:58:04,625 INFO [STDOUT] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
14:58:04,625 INFO [STDOUT] at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
14:58:04,625 INFO [STDOUT] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
14:58:04,625 INFO [STDOUT] at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
14:58:04,625 INFO [STDOUT] at org.jbpm.db.TaskMgmtSession.findTaskInstances(TaskMgmtSession.java:34)
14:58:04,625 INFO [STDOUT] ... 40 more
14:58:04,625 INFO [STDOUT] Caused by: java.sql.SQLException: ORA-00904: "FALSE": invalid identifier
14:58:04,625 INFO [STDOUT] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
14:58:04,625 INFO [STDOUT] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
14:58:04,625 INFO [STDOUT] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
14:58:04,625 INFO [STDOUT] at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
14:58:04,625 INFO [STDOUT] at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
14:58:04,625 INFO [STDOUT] at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
14:58:04,640 INFO [STDOUT] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
14:58:04,640 INFO [STDOUT] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
14:58:04,640 INFO [STDOUT] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)
14:58:04,640 INFO [STDOUT] at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)
14:58:04,640 INFO [STDOUT] at org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
14:58:04,640 INFO [STDOUT] at org.hibernate.loader.Loader.doQuery(Loader.java:391)
14:58:04,640 INFO [STDOUT] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
14:58:04,640 INFO [STDOUT] at org.hibernate.loader.Loader.doList(Loader.java:1593)
14:58:04,640 INFO [STDOUT] ... 46 more
14:58:06,656 INFO [STDOUT] java.lang.RuntimeException: couldn't get task instances list for actor 'Supervisor'
14:58:06,671 INFO [STDOUT] at org.jbpm.db.TaskMgmtSession.findTaskInstances(TaskMgmtSession.java:38)
14:58:06,671 INFO [STDOUT] at com.tcs.jbpm.workflow.JbpmInterface.fetchTaskInstances(JbpmInterface.java:178)
14:58:06,671 INFO [STDOUT] at com.tcs.jbpmPoc.workflow.WorkflowAdpater.fetchTasks(WorkflowAdpater.java:35)
14:58:06,671 INFO [STDOUT] at com.tcs.jbpmPoc.ejb.LeaveTestBeanImpl.getWorkList(LeaveTestBeanImpl.java:82)
14:58:06,671 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
14:58:06,671 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
14:58:06,671 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
14:58:06,671 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
14:58:06,687 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
14:58:06,687 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
14:58:06,687 INFO [STDOUT] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
14:58:06,687 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
14:58:06,687 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)
14:58:06,687 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)
14:58:06,687 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:111)
14:58:06,687 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
14:58:06,703 INFO [STDOUT] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
14:58:06,703 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
14:58:06,703 INFO [STDOUT] at org.jboss.ejb.Container.invoke(Container.java:709)
14:58:06,703 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
14:58:06,703 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
14:58:06,703 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
14:58:06,703 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
14:58:06,703 INFO [STDOUT] at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
14:58:06,703 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62)
14:58:06,703 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54)
14:58:06,718 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:82)
14:58:06,718 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:197)
14:58:06,718 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
14:58:06,718 INFO [STDOUT] at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:360)
14:58:06,718 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
14:58:06,718 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
14:58:06,718 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
14:58:06,718 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
14:58:06,718 INFO [STDOUT] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
14:58:06,718 INFO [STDOUT] at sun.rmi.transport.Transport$1.run(Transport.java:148)
14:58:06,718 INFO [STDOUT] at java.security.AccessController.doPrivileged(Native Method)
14:58:06,718 INFO [STDOUT] at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
14:58:06,734 INFO [STDOUT] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
14:58:06,734 INFO [STDOUT] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
14:58:06,734 INFO [STDOUT] at java.lang.Thread.run(Thread.java:534)
14:58:06,734 INFO [STDOUT] Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
14:58:06,734 INFO [STDOUT] at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70)
14:58:06,734 INFO [STDOUT] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
14:58:06,734 INFO [STDOUT] at org.hibernate.loader.Loader.doList(Loader.java:1596)
14:58:06,734 INFO [STDOUT] at org.hibernate.loader.Loader.list(Loader.java:1577)
14:58:06,734 INFO [STDOUT] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
14:58:06,734 INFO [STDOUT] at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
14:58:06,734 INFO [STDOUT] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
14:58:06,734 INFO [STDOUT] at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
14:58:06,734 INFO [STDOUT] at org.jbpm.db.TaskMgmtSession.findTaskInstances(TaskMgmtSession.java:34)
14:58:06,734 INFO [STDOUT] ... 40 more
14:58:06,750 INFO [STDOUT] Caused by: java.sql.SQLException: ORA-00904: "FALSE": invalid identifier
14:58:06,750 INFO [STDOUT] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
14:58:06,750 INFO [STDOUT] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
14:58:06,750 INFO [STDOUT] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
14:58:06,750 INFO [STDOUT] at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
14:58:06,750 INFO [STDOUT] at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
14:58:06,750 INFO [STDOUT] at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
14:58:06,750 INFO [STDOUT] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
14:58:06,750 INFO [STDOUT] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
14:58:06,750 INFO [STDOUT] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)
14:58:06,750 INFO [STDOUT] at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)
14:58:06,750 INFO [STDOUT] at org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
14:58:06,750 INFO [STDOUT] at org.hibernate.loader.Loader.doQuery(Loader.java:391)
14:58:06,765 INFO [STDOUT] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
14:58:06,765 INFO [STDOUT] at org.hibernate.loader.Loader.doList(Loader.java:1593)
14:58:06,765 INFO [STDOUT] ... 46 more
14:58:10,750 ERROR [LogInterceptor] RuntimeException in method: public abstract java.util.ArrayList com.tcs.jbpmPoc.ejb.LeaveTestRemote.getWorkList(java.lang.String) throws java.rmi.RemoteException,java.lang.Exception
java.lang.RuntimeException: couldn't get task instances list for actor 'Supervisor'
at org.jbpm.db.TaskMgmtSession.findTaskInstances(TaskMgmtSession.java:38)
at com.tcs.jbpm.workflow.JbpmInterface.fetchTaskInstances(JbpmInterface.java:178)
at com.tcs.jbpmPoc.workflow.WorkflowAdpater.fetchTasks(WorkflowAdpater.java:35)
at com.tcs.jbpmPoc.ejb.LeaveTestBeanImpl.getWorkList(LeaveTestBeanImpl.java:82)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:111)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
at org.jboss.ejb.Container.invoke(Container.java:709)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:82)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:197)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:360)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:1596)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at org.jbpm.db.TaskMgmtSession.findTaskInstances(TaskMgmtSession.java:34)
... 40 more
Caused by: java.sql.SQLException: ORA-00904: "FALSE": invalid identifier
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
at org.hibernate.loader.Loader.doQuery(Loader.java:391)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
... 46 more
Any idea or suggestion is appreciated.
Regards
Pratap.