[JBoss jBPM] - Getting SQLGrammarException when installing jBPM BPEL 1.1-Be
by qliu
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#4028900
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4028900
19Â years, 1Â month
[JBoss Seam] - Re: propagation
by codelion
If you say what it isn't, also say what it is:
### Eclipse Workspace Patch 1.0
| #P jboss-seam
| Index: doc/reference/en/modules/conversations.xml
| ===================================================================
| RCS file: /cvsroot/jboss/jboss-seam/doc/reference/en/modules/conversations.xml,v
| retrieving revision 1.27
| diff -u -r1.27 conversations.xml
| --- doc/reference/en/modules/conversations.xml 27 Feb 2007 00:03:28 -0000 1.27
| +++ doc/reference/en/modules/conversations.xml 16 Mar 2007 17:23:30 -0000
| @@ -167,6 +167,12 @@
| <para>
| Note that disabling conversation context propagation is absolutely not the
| same thing as ending the conversation.
| + Ending causes the conversation to be demoted to a temporary conversation
| + (which then ends at the end of the current request).
| + None causes the conversation not to be propagated - if you looked at the
| + conversation list on debug.xhtml or displayed a list of conversations to
| + the user it would still be there (just not active).
| + Inactive conversations timeout (set via components.xml).
| </para>
|
| <para>
Thanks for explaining it, Pete.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4028894#4028894
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4028894
19Â years, 1Â month