[jboss-user] [JBoss jBPM] - Getting SQLGrammarException when installing jBPM BPEL 1.1-Be

I am getting the following SQLGrammarException when installing jBPM BPEL 1.1-Beta3: (I am using jBoss 4.0.5.GA and jbpm-bpel-1.1-Beta3) =============================================================================== 10:29:17,820 WARN [JDBCExceptionReporter] SQL Error: 923, SQLState: 42000 10:29:17,820 ERROR [JDBCExceptionReporter] ORA-00923: FROM keyword not found whe re expected 10:29:17,820 ERROR [JobSession] org.hibernate.exception.SQLGrammarException: cou ld not execute query 10:29:17,835 ERROR [JobExecutorThread] exception in job executor thread. waiting 60000 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 ) =============================================================================== And the server log file shows the following: =============================================================================== 2007-03-16 10:29:17,508 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors 2007-03-16 10:29:17,508 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors 2007-03-16 10:29:17,508 DEBUG [org.hibernate.impl.SessionFactoryImpl] Checking 0 named SQL queries 2007-03-16 10:29:17,524 DEBUG [org.jbpm.persistence.db.DbPersistenceService] creating hibernate session 2007-03-16 10:29:17,586 DEBUG [org.hibernate.impl.SessionImpl] opened session at timestamp: 4808974981218304 2007-03-16 10:29:17,586 DEBUG [org.jbpm.persistence.db.DbPersistenceService] beginning hibernate transaction 2007-03-16 10:29:17,586 DEBUG [org.hibernate.transaction.JDBCTransaction] begin 2007-03-16 10:29:17,586 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection 2007-03-16 10:29:17,586 DEBUG [org.hibernate.transaction.JDBCTransaction] current autocommit status: true 2007-03-16 10:29:17,586 DEBUG [org.hibernate.transaction.JDBCTransaction] disabling autocommit 2007-03-16 10:29:17,586 DEBUG [org.jbpm.job.executor.JobExecutorThread] querying for acquirable job... 2007-03-16 10:29:17,602 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0) 2007-03-16 10:29:17,602 DEBUG [org.hibernate.SQL] select top ? job0_.ID_ as ID1_25_, job0_.VERSION_ as VERSION3_25_, job0_.DUEDATE_ as DUEDATE4_25_, job0_.PROCESSINSTANCE_ as PROCESSI5_25_, job0_.TOKEN_ as TOKEN6_25_, job0_.TASKINSTANCE_ as TASKINST7_25_, job0_.ISSUSPENDED_ as ISSUSPEN8_25_, job0_.ISEXCLUSIVE_ as ISEXCLUS9_25_, job0_.LOCKOWNER_ as LOCKOWNER10_25_, job0_.LOCKTIME_ as LOCKTIME11_25_, job0_.EXCEPTION_ as EXCEPTION12_25_, job0_.RETRIES_ as RETRIES13_25_, job0_.NAME_ as NAME14_25_, job0_.REPEAT_ as REPEAT15_25_, job0_.TRANSITIONNAME_ as TRANSIT16_25_, job0_.ACTION_ as ACTION17_25_, job0_.GRAPHELEMENTTYPE_ as GRAPHEL18_25_, job0_.GRAPHELEMENT_ as GRAPHEL19_25_, job0_.NODE_ as NODE20_25_, job0_.CLASS_ as CLASS2_25_ from JBPM_JOB job0_ where (job0_.LOCKOWNER_ is null or job0_.LOCKOWNER_=?) and job0_.RETRIES_>0 and job0_.DUEDATE_<=? and job0_.ISSUSPENDED_<>1 order by job0_.DUEDATE_ asc 2007-03-16 10:29:17,788 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() JbpmJobExecutor:192.168.1.36:1 -> lockOwner [2] 2007-03-16 10:29:17,788 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() Fri Mar 16 10:29:17 PDT 2007 -> now [3] 2007-03-16 10:29:17,820 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1) 2007-03-16 10:29:17,820 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not execute query [select job0_.ID_ as ID1_25_, job0_.VERSION_ as VERSION3_25_, job0_.DUEDATE_ as DUEDATE4_25_, job0_.PROCESSINSTANCE_ as PROCESSI5_25_, job0_.TOKEN_ as TOKEN6_25_, job0_.TASKINSTANCE_ as TASKINST7_25_, job0_.ISSUSPENDED_ as ISSUSPEN8_25_, job0_.ISEXCLUSIVE_ as ISEXCLUS9_25_, job0_.LOCKOWNER_ as LOCKOWNER10_25_, job0_.LOCKTIME_ as LOCKTIME11_25_, job0_.EXCEPTION_ as EXCEPTION12_25_, job0_.RETRIES_ as RETRIES13_25_, job0_.NAME_ as NAME14_25_, job0_.REPEAT_ as REPEAT15_25_, job0_.TRANSITIONNAME_ as TRANSIT16_25_, job0_.ACTION_ as ACTION17_25_, job0_.GRAPHELEMENTTYPE_ as GRAPHEL18_25_, job0_.GRAPHELEMENT_ as GRAPHEL19_25_, job0_.NODE_ as NODE20_25_, job0_.CLASS_ as CLASS2_25_ from JBPM_JOB job0_ where (job0_.LOCKOWNER_ is null or job0_.LOCKOWNER_=?) and job0_.RETRIES_>0 and job0_.DUEDATE_<=? and job0_.ISSUSPENDED_<>1 order by job0_.DUEDATE_ asc] java.sql.SQLException: ORA-00923: FROM keyword not found where expected at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:965) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1051) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3026) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1668) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2144) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028) at org.hibernate.loader.Loader.list(Loader.java:2023) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java: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.java:780) at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:40) at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread.java:111) at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:56) 2007-03-16 10:29:17,820 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 923, SQLState: 42000 2007-03-16 10:29:17,820 ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-00923: FROM keyword not found where expected 2007-03-16 10:29:17,820 ERROR [org.jbpm.db.JobSession] org.hibernate.exception.SQLGrammarException: could not execute query 2007-03-16 10:29:17,835 DEBUG [org.jbpm.JbpmContext] closing JbpmContext 2007-03-16 10:29:17,835 DEBUG [org.jbpm.svc.Services] closing service 'persistence': org.jbpm.bpel.persistence.db.DbPersistenceService@20ea6c 2007-03-16 10:29:17,835 DEBUG [org.jbpm.persistence.db.DbPersistenceService] committing hibernate transaction 2007-03-16 10:29:17,835 DEBUG [org.hibernate.transaction.JDBCTransaction] commit 2007-03-16 10:29:17,835 DEBUG [org.hibernate.transaction.JDBCTransaction] re-enabling autocommit 2007-03-16 10:29:17,835 DEBUG [org.hibernate.transaction.JDBCTransaction] committed JDBC Connection 2007-03-16 10:29:17,835 DEBUG [org.hibernate.jdbc.ConnectionManager] aggressively releasing JDBC connection 2007-03-16 10:29:17,835 DEBUG [org.hibernate.jdbc.ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)] 2007-03-16 10:29:17,835 DEBUG [org.jbpm.persistence.db.DbPersistenceService] closing hibernate session 2007-03-16 10:29:17,835 DEBUG [org.jbpm.svc.Services] closing service 'tx': org.jbpm.tx.TxService@64af0f 2007-03-16 10:29:17,835 ERROR [org.jbpm.job.executor.JobExecutorThread] exception in job executor thread. waiting 60000 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.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2147) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028) at org.hibernate.loader.Loader.list(Loader.java:2023) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java: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.java:780) at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:40) ... 2 more Caused by: java.sql.SQLException: ORA-00923: FROM keyword not found where expected at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:965) at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1051) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3026) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1668) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2144) ... 11 more =============================================================================== Please help. Thanks. Qingdi View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4028900#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...