5 Replies Latest reply on Nov 10, 2005 2:15 PM by Olivier Kloss

    jBPM Oracle Exception

    Sivajee Akula Newbie

      Hello 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.

        • 1. Re: jBPM Oracle Exception
          Ronald van Kuijk Master

          search the forum on oracle and false (or true) I bet you get a number of hits.....

          • 2. Re: jBPM Oracle Exception
            sateesh kumar Newbie

            Hi,

            Could u pls let me know how you resolved this one..

            Thanks
            Sateesh

            • 3. Re: jBPM Oracle Exception
              sateesh kumar Newbie

              Hi,

              I am getting the below Error :
              Caused by: java.sql.SQLException: ORA-00904: "FALSE": invalid identifier

              When i try to fecth the Task List for the logged in user.. ( I am running the app on WLS8.1 SP4 and DB is Oracle10g)

              When i looked into the Code we are firing the HQL Query

              select
              ti
              from
              org.jbpm.taskmgmt.exe.TaskInstance as ti
              where
              ti.actorId = :actorId
              and ti.end is null
              and ti.isCancelled = false

              which i guess is converted as the below SQL Query for Oracle by hibernate

              select
              count(*)
              from
              JBPM_TASKINSTANCE
              WHERE
              ACTORID_='swright'
              and END_ is NULL
              and ISCANCELLED_ = FALSE;

              which gives the below error when executed in SQL Console

              ERROR at line 1:
              ORA-00904: "FALSE": invalid identifier

              ISCANCELLED_ is declared as NUMBER(1) SQL Type..

              The Query should be

              select
              count(*)
              from
              JBPM_TASKINSTANCE
              WHERE
              ACTORID_='swright'
              and END_ is NULL
              and ISCANCELLED_ = FALSE;


              Do we need to set the below property in hibernate ??

              true 1, false 0


              Pls let me know...

              ~Sateesh



              • 4. Re: jBPM Oracle Exception
                sateesh kumar Newbie

                I Changed the Query in TaskMgmtSession.java to

                private static final String findTaskInstancesByActorId =
                "select ti " +
                "from org.jbpm.taskmgmt.exe.TaskInstance as ti " +
                "where ti.actorId = :actorId " +
                " and ti.end is null " +
                " and ti.isCancelled = 0";

                and it working fine..I don't know the implications of this change though..

                Sateesh

                "kls_kumar" wrote:
                Hi,

                I am getting the below Error :
                Caused by: java.sql.SQLException: ORA-00904: "FALSE": invalid identifier

                When i try to fecth the Task List for the logged in user.. ( I am running the app on WLS8.1 SP4 and DB is Oracle10g)

                When i looked into the Code we are firing the HQL Query

                select
                ti
                from
                org.jbpm.taskmgmt.exe.TaskInstance as ti
                where
                ti.actorId = :actorId
                and ti.end is null
                and ti.isCancelled = false

                which i guess is converted as the below SQL Query for Oracle by hibernate

                select
                count(*)
                from
                JBPM_TASKINSTANCE
                WHERE
                ACTORID_='swright'
                and END_ is NULL
                and ISCANCELLED_ = FALSE;

                which gives the below error when executed in SQL Console

                ERROR at line 1:
                ORA-00904: "FALSE": invalid identifier

                ISCANCELLED_ is declared as NUMBER(1) SQL Type..

                The Query should be

                select
                count(*)
                from
                JBPM_TASKINSTANCE
                WHERE
                ACTORID_='swright'
                and END_ is NULL
                and ISCANCELLED_ = 0;


                Do we need to set the below property in hibernate ??

                <property name="hibernate.query.substitutions">true 1, false 0</property>


                Pls let me know...

                ~Sateesh





                • 5. Re: jBPM Oracle Exception
                  Olivier Kloss Newbie

                  I think you just need to make sure the following is set in your hibernate.properties file:

                  hibernate.query.substitutions=true 1, false 0
                  

                  If you search this forum about this, I think you'll find the answer.