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': [EMAIL PROTECTED]
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':
[EMAIL PROTECTED]
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
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
