Sam Mano [https://community.jboss.org/people/artist123] created the discussion
"Re: JBPM5.3-installer, jbpm-console persistence error" To view the discussion, visit: https://community.jboss.org/message/750579#750579 -------------------------------------------------------------- add to my privious post... after restate the all and try using the ant start.demo.db... I go the following error... :\JBPM\jbpm-installer>ant start.demo.db uildfile: D:\JBPM\jbpm-installer\build.xml heck.jboss.version: ownload.db.driver.check: [echo] Checking if db driver jar has been downloaded ... ownload.mysql.driver: nstall.db.files: [mkdir] Created dir: D:\JBPM\jbpm-installer\jboss-as-7.0.2.Final\modules\com\mysql\main [copy] Copying 1 file to D:\JBPM\jbpm-installer\jboss-as-7.0.2.Final\modules\com\mysql\main [copy] Copying 1 file to D:\JBPM\jbpm-installer\jboss-as-7.0.2.Final\modules\com\mysql\main tart.jboss: heck.jboss.version: tart.jboss5: heck.jboss.version: tart.jboss7: tart.human.task: [javac] D:\JBPM\jbpm-installer\build.xml:844: warning: 'includeantruntime' was not set, defaulting to build.sysclass ath=last; set to false for repeatable builds [java] 0 26/07 17:48:42,883[main] ERROR hibernate.util.JDBCExceptionReporter.logExceptions - Table 'task.organi ationalentity' doesn't exist [java] 0 26/07 17:48:42,883[main] ERROR event.def.AbstractFlushingEventListener.performExecutions - Could not s nchronize database state with session [java] org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update [java] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) [java] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) [java] at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) [java] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266) [java] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167) [java] at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener java:321) [java] at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50) [java] at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028) [java] at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:366) [java] at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137) [java] at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54) [java] at org.jbpm.task.service.persistence.TaskLocalTransactionManager.commit(TaskLocalTransactionManager.java 55) [java] at org.jbpm.task.service.persistence.TaskPersistenceManager.endTransaction(TaskPersistenceManager.java:8 ) [java] at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:982) [java] at org.jbpm.task.service.TaskServiceSession.persistInTransaction(TaskServiceSession.java:957) [java] at org.jbpm.task.service.TaskServiceSession.addGroup(TaskServiceSession.java:119) [java] at org.jbpm.DemoTaskService.main(Unknown Source) [java] Caused by: java.sql.BatchUpdateException: Table 'task.organizationalentity' doesn't exist [java] at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2054) [java] at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467) [java] at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) [java] at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) [java] ... 14 more [java] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'task.organizationalentity' does 't exist [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:44) [java] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) [java] at java.lang.reflect.Constructor.newInstance(Constructor.java:516) [java] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) [java] at com.mysql.jdbc.Util.getInstance(Util.java:386) [java] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053) [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074) [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006) [java] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468) [java] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629) [java] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719) [java] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) [java] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2450) [java] at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2006) [java] ... 17 more [java] 30 26/07 17:48:42,913[main] WARN service.persistence.TaskLocalTransactionManager.commit - Unable to begi transaction [java] javax.persistence.RollbackException: Error while commiting the transaction [java] at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71) [java] at org.jbpm.task.service.persistence.TaskLocalTransactionManager.commit(TaskLocalTransactionManager.java 55) [java] at org.jbpm.task.service.persistence.TaskPersistenceManager.endTransaction(TaskPersistenceManager.java:8 ) [java] at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:982) [java] at org.jbpm.task.service.TaskServiceSession.persistInTransaction(TaskServiceSession.java:957) [java] at org.jbpm.task.service.TaskServiceSession.addGroup(TaskServiceSession.java:119) [java] at org.jbpm.DemoTaskService.main(Unknown Source) [java] Caused by: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update [java] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) [java] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) [java] at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) [java] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266) [java] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167) [java] at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener java:321) [java] at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50) [java] at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028) [java] at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:366) [java] at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137) [java] at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54) [java] ... 6 more [java] Caused by: java.sql.BatchUpdateException: Table 'task.organizationalentity' doesn't exist [java] at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2054) [java] at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467) [java] at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) [java] at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) [java] ... 14 more [java] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'task.organizationalentity' does 't exist [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:44) [java] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) [java] at java.lang.reflect.Constructor.newInstance(Constructor.java:516) [java] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) [java] at com.mysql.jdbc.Util.getInstance(Util.java:386) [java] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053) [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074) [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006) [java] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468) [java] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629) [java] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719) [java] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) [java] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2450) [java] at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2006) [java] ... 17 more [java] 110 26/07 17:48:42,993[main] ERROR service.persistence.TaskPersistenceManager.endTransaction - Unable to c mmit, rolling back transaction. [java] java.lang.RuntimeException: Unable to commit transaction [java] at org.jbpm.task.service.persistence.TaskLocalTransactionManager.commit(TaskLocalTransactionManager.java 59) [java] at org.jbpm.task.service.persistence.TaskPersistenceManager.endTransaction(TaskPersistenceManager.java:8 ) [java] at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:982) [java] at org.jbpm.task.service.TaskServiceSession.persistInTransaction(TaskServiceSession.java:957) [java] at org.jbpm.task.service.TaskServiceSession.addGroup(TaskServiceSession.java:119) [java] at org.jbpm.DemoTaskService.main(Unknown Source) [java] Caused by: javax.persistence.RollbackException: Error while commiting the transaction [java] at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71) [java] at org.jbpm.task.service.persistence.TaskLocalTransactionManager.commit(TaskLocalTransactionManager.java 55) [java] ... 5 more [java] Caused by: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update [java] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) [java] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) [java] at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) [java] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266) [java] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167) [java] at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener java:321) [java] at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50) [java] at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028) [java] at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:366) [java] at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137) [java] at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54) [java] ... 6 more [java] Caused by: java.sql.BatchUpdateException: Table 'task.organizationalentity' doesn't exist [java] at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2054) [java] at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467) [java] at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) [java] at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) [java] ... 14 more [java] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'task.organizationalentity' does 't exist [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [java] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:44) [java] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) [java] at java.lang.reflect.Constructor.newInstance(Constructor.java:516) [java] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) [java] at com.mysql.jdbc.Util.getInstance(Util.java:386) [java] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053) [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074) [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006) [java] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468) [java] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629) [java] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719) [java] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) [java] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2450) [java] at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2006) [java] ... 17 more [java] 210 26/07 17:48:43,093[main] WARN service.persistence.TaskLocalTransactionManager.rollback - Unable to ro lback transaction [java] java.lang.IllegalStateException: Transaction not active [java] at org.hibernate.ejb.TransactionImpl.rollback(TransactionImpl.java:82) [java] at org.jbpm.task.service.persistence.TaskLocalTransactionManager.rollback(TaskLocalTransactionManager.ja a:70) [java] at org.jbpm.task.service.persistence.TaskPersistenceManager.endTransaction(TaskPersistenceManager.java:8 ) [java] at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:982) [java] at org.jbpm.task.service.TaskServiceSession.persistInTransaction(TaskServiceSession.java:957) [java] at org.jbpm.task.service.TaskServiceSession.addGroup(TaskServiceSession.java:119) [java] at org.jbpm.DemoTaskService.main(Unknown Source) [java] 300 26/07 17:48:43,183[main] WARN service.persistence.TaskLocalTransactionManager.rollback - Unable to ro lback transaction [java] java.lang.IllegalStateException: Transaction not active [java] at org.hibernate.ejb.TransactionImpl.rollback(TransactionImpl.java:82) [java] at org.jbpm.task.service.persistence.TaskLocalTransactionManager.rollback(TaskLocalTransactionManager.ja a:70) [java] at org.jbpm.task.service.persistence.TaskPersistenceManager.rollBackTransaction(TaskPersistenceManager.j va:97) [java] at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:984) [java] at org.jbpm.task.service.TaskServiceSession.persistInTransaction(TaskServiceSession.java:957) [java] at org.jbpm.task.service.TaskServiceSession.addGroup(TaskServiceSession.java:119) [java] at org.jbpm.DemoTaskService.main(Unknown Source) [java] 320 26/07 17:48:43,203[main] ERROR service.persistence.TaskPersistenceManager.rollBackTransaction - Unable to rollback transaction (or to mark as 'to rollback')! [java] java.lang.RuntimeException: Unable to rollback transaction [java] at org.jbpm.task.service.persistence.TaskLocalTransactionManager.rollback(TaskLocalTransactionManager.ja a:77) [java] at org.jbpm.task.service.persistence.TaskPersistenceManager.rollBackTransaction(TaskPersistenceManager.j va:97) [java] at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:984) [java] at org.jbpm.task.service.TaskServiceSession.persistInTransaction(TaskServiceSession.java:957) [java] at org.jbpm.task.service.TaskServiceSession.addGroup(TaskServiceSession.java:119) [java] at org.jbpm.DemoTaskService.main(Unknown Source) [java] Caused by: java.lang.IllegalStateException: Transaction not active [java] at org.hibernate.ejb.TransactionImpl.rollback(TransactionImpl.java:82) [java] at org.jbpm.task.service.persistence.TaskLocalTransactionManager.rollback(TaskLocalTransactionManager.ja a:70) [java] ... 5 more [java] Exception in thread "main" java.lang.RuntimeException: Could not commit transaction [java] at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:994) [java] at org.jbpm.task.service.TaskServiceSession.persistInTransaction(TaskServiceSession.java:957) [java] at org.jbpm.task.service.TaskServiceSession.addGroup(TaskServiceSession.java:119) [java] at org.jbpm.DemoTaskService.main(Unknown Source) [java] Caused by: java.lang.RuntimeException: Unable to rollback transaction [java] at org.jbpm.task.service.persistence.TaskLocalTransactionManager.rollback(TaskLocalTransactionManager.ja a:77) [java] at org.jbpm.task.service.persistence.TaskPersistenceManager.endTransaction(TaskPersistenceManager.java:8 ) [java] at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:982) [java] ... 3 more [java] Caused by: java.lang.IllegalStateException: Transaction not active [java] at org.hibernate.ejb.TransactionImpl.rollback(TransactionImpl.java:82) [java] at org.jbpm.task.service.persistence.TaskLocalTransactionManager.rollback(TaskLocalTransactionManager.ja a:70) [java] ... 5 more [java] Java Result: 1 tart.demo.db: UILD SUCCESSFUL -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/750579#750579] Start a new discussion in jBPM at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]
_______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
