[JBoss jBPM] - Re: change database
by fuligj
I have tried to change th db in jbpm-jpdl-3.2.Beta1.
but...:
| 10:05:30,047 DEBUG [JobExecutorThread] acquiring jobs for execution...
| 10:05:31,062 DEBUG [JbpmContextInfo] creating jbpm context with service factorie
| s '[tx, message, scheduler, logging, persistence, authentication]'
| 10:05:31,062 DEBUG [JbpmContext] creating org.jbpm.JbpmContext@193b604
| 10:05:31,062 DEBUG [DbPersistenceServiceFactory] creating persistence service
| 10:05:31,062 DEBUG [DbPersistenceService] creating hibernate session
| 10:05:31,078 DEBUG [DbPersistenceService] beginning hibernate transaction
| 10:05:31,078 DEBUG [JobExecutorThread] querying for acquirable job...
| 10:05:31,078 WARN [JDBCExceptionReporter] SQL Error: 1064, SQLState: 42000
| 10:05:31,078 ERROR [JDBCExceptionReporter] You have an error in your SQL syntax;
| check the manual that corresponds to your MySQL server version for the right sy
| ntax to use near '1 job0_.ID_ as ID1_26_, job0_.VERSION_ as VERSION3_26_, job0_.
| DUEDATE_ as DUEDAT' at line 1
| 10:05:31,078 ERROR [JobSession] org.hibernate.exception.SQLGrammarException: cou
| ld not execute query
| 10:05:31,078 DEBUG [JbpmContext] closing JbpmContext
| 10:05:31,078 DEBUG [Services] closing service 'persistence': org.jbpm.persistenc
| e.db.DbPersistenceService@148ab5c
| 10:05:31,078 DEBUG [DbPersistenceService] committing hibernate transaction
| 10:05:31,078 DEBUG [DbPersistenceService] closing hibernate session
| 10:05:31,078 DEBUG [Services] closing service 'tx': org.jbpm.tx.TxService@1ea2de
| 1
| 10:05:31,078 ERROR [JobExecutorThread] exception in job executor thread. waiting
| 80000 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:2148)
| at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
| at org.hibernate.loader.Loader.list(Loader.java:2024)
| at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:392)
| at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja
| va:333)
| at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java
| :172)
| at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
| at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
| at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.j
| ava:756)
| at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:40)
| ... 2 more
| Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an erro
| r in your SQL syntax; check the manual that corresponds to your MySQL server ver
| sion for the right syntax to use near '1 job0_.ID_ as ID1_26_, job0_.VERSION_ as
| VERSION3_26_, job0_.DUEDATE_ as DUEDAT' at line 1
| at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
| at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
| at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
| at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
| at com.mysql.jdbc.Connection.execSQL(Connection.java:3176)
| at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
| va:1153)
| at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
| 1266)
| 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:1669)
| at org.hibernate.loader.Loader.doQuery(Loader.java:662)
| at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
| ader.java:224)
| at org.hibernate.loader.Loader.doList(Loader.java:2145)
| ... 11 more
|
Can anyone help me?
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4006713#4006713
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4006713
19 years, 2 months