[jboss-user] [jBPM] - Re: Help!After replacing H2 to mysql, getting errors in the process tab!

[Jimmy dong]

Jimmy dong [http://community.jboss.org/people/jimmy.dongjia] created the discussion

"Re: Help!After replacing H2 to mysql,getting errors in the process tab!"

To view the discussion, visit: http://community.jboss.org/message/642130#642130

--------------------------------------------------------------
Hi Demian!
When I set hibernate.hbm2ddl.auto=create  to update, after I restart  HT server, the HT server can't run , error as follow:

[javac] /usr/local/jbpm-installer/build.xml:500: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false for repeatable builds
     [java] Exception in thread "main" javax.persistence.RollbackException: Error while commiting the transaction
     [java]  at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71)
     [java]  at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:820)
     [java]  at org.jbpm.task.service.TaskServiceSession.persistInTransaction(TaskServiceSession.java:786)
     [java]  at org.jbpm.task.service.TaskServiceSession.addUser(TaskServiceSession.java:69)
     [java]  at org.jbpm.DemoTaskService.main(Unknown Source)
     [java] Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
     [java]  at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
     [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:1027)
     [java]  at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
     [java]  at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
     [java]  at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
     [java]  ... 4 more
     [java] Caused by: java.sql.BatchUpdateException: Duplicate entry 'Jane Austin' for key 'PRIMARY'
     [java]  at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2028)
     [java]  at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1451)
     [java]  at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
     [java]  at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
     [java]  ... 12 more
     [java] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'Jane Austin' for key 'PRIMARY'
     [java]  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
     [java]  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
     [java]  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
     [java]  at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
     [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:1039)
     [java]  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
     [java]  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
     [java]  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
     [java]  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
     [java]  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
     [java]  at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
     [java]  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427)
     [java]  at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1980)
     [java]  ... 15 more
     [java] Java Result: 1
BUILD SUCCESSFUL
Total time: 30 seconds
[root at localhost jbpm-installer]# 

--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/642130#642130]

Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20111218/9adae488/attachment.html