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

qliu do-not-reply at jboss.com
Fri Mar 16 13:36:43 EDT 2007 

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 at 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 at 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#4028900

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4028900

More information about the jboss-user mailing list