Hi, i have encountred some issue while testing jbpm. Here what i have done : Deploying my processdefinition with the deployer of the jbpm Designer eclipse plugin. Checking in the database for that processdefinition : it appeared.
In my Struts action : JbpmConfiguration jbpmConfiguration=JbpmConfiguration.getInstance(); JbpmContext jbpmContext=jbpmConfiguration.createJbpmContext(); jbpmConfiguration.createSchema(); ProcessDefinition processDefinition=ProcessDefinition.parseXmlResource("demandeAccesVerifUserAlerteRH/processdefinition.xml"); This throws an exception : 17:06:21,822 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000 17:06:21,822 ERROR [JDBCExceptionReporter] ORA-00942: Table ou vue inexistante 17:06:21,822 ERROR [JobSession] org.hibernate.exception.SQLGrammarException: cou ld not execute query 17:06:21,838 ERROR [JobExecutorThread] exception in job executor thread. waiting 5000 milliseconds org.jbpm.JbpmException: couldn't get acquirable jobs at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:44) at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread .java:111) at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:56 ) Caused by: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j ava:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp er.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2223) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja va:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java :172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.j ava:811) at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:40) ... 2 more Caused by: java.sql.SQLException: ORA-00942: Table ou vue inexistante 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.jav a:2391) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme nt.java:2672) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar edStatement.java:589) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare dStatement.java:527) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java: 186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo ader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2220) ... 11 more 17:06:26,931 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000 17:06:26,931 ERROR [JDBCExceptionReporter] ORA-00942: Table ou vue inexistante 17:06:26,931 ERROR [JobSession] org.hibernate.exception.SQLGrammarException: cou ld not execute query 17:06:26,931 ERROR [JobExecutorThread] exception in job executor thread. waiting 10000 milliseconds org.jbpm.JbpmException: couldn't get acquirable jobs at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:44) at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread .java:111) at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:56 ) Caused by: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j ava:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp er.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2223) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja va:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java :172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.j ava:811) at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:40) ... 2 more Caused by: java.sql.SQLException: ORA-00942: Table ou vue inexistante 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.jav a:2391) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme nt.java:2672) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar edStatement.java:589) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare dStatement.java:527) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java: 186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo ader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2220) ... 11 more If someone know about this or has already encountred that issue, please keep me posted. Best regards, O.M. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4064597#4064597 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4064597 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user