hibernate problems with BPEL Extension
joshua_hj Nov 21, 2005 3:50 PMDear community,
I was trying to put the ATM example up and running. Everything works fine at deployment time, according to the docs. I am using MySQL as database, and the Hello World example works fine. I can see the process definitions beeing deplyed and the process instances being generated.
The thing is when running the ATM example i have an hibernate exception:
20:40:47,895 INFO [[/atm]] messagerServlet: BPEL application stopped 20:40:47,905 INFO [AxisService] WebService undeployed: http://runner:8080/atm/frontEnd 20:40:48,576 INFO [EARDeployer] Undeploying J2EE application, destroy step: file:/C:/Java/jboss-4.0.2/server/bpel/deploy/atm-application.ear 20:40:48,576 WARN [DeploymentInfo] Could not delete file:/C:/Java/jboss-4.0.2/server/bpel/tmp/deploy/tmp44799atm-application.ear restart will delete it 20:40:48,586 INFO [EARDeployer] Init J2EE application: file:/C:/Java/jboss-4.0.2/server/bpel/deploy/atm-application.ear 20:40:48,937 INFO [TomcatDeployer] deploy, ctxPath=/atm, warUrl=file:/C:/Java/jboss-4.0.2/server/bpel/tmp/deploy/tmp44800atm-application.ear-contents/atm-web-e xp.war/ 20:40:49,878 INFO [[/atm]] messagerServlet: BPEL application started: atm 20:40:49,938 INFO [WSDLFilePublisher] WSDL published to: file:/C:/Java/jboss-4.0.2/server/bpel/data/wsdl/atm-application.ear/atm-web.war/service.wsdl 20:40:50,169 INFO [AxisService] WSDD published to: C:\Java\jboss-4.0.2\server\bpel\data\wsdl\atm-application.ear\atm-web.war\frontEndPort.wsdd 20:40:50,179 INFO [AxisService] Web Service deployed: http://runner:8080/atm/frontEnd 20:40:50,219 INFO [EARDeployer] Started J2EE application: file:/C:/Java/jboss-4.0.2/server/bpel/deploy/atm-application.ear 20:41:20,072 ERROR [AbstractBatcher] Exception executing batch: org.hibernate.StaleStateException: Batch update returned unexpected row count from update: 1 actual row count: 0 expected: 1 at org.hibernate.jdbc.BatchingBatcher.checkRowCount(BatchingBatcher.java:93) at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:79) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:193) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:91) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:86) at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:169) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2162) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2117) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2373) at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:84) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:905) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:345) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at org.jbpm.bpel.service.messager.StartListener.onMessage(StartListener.java:123) at org.jboss.mq.SpyMessageConsumer.run(SpyMessageConsumer.java:707) at java.lang.Thread.run(Thread.java:595) 20:41:20,072 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session org.hibernate.StaleStateException: Batch update returned unexpected row count from update: 1 actual row count: 0 expected: 1 at org.hibernate.jdbc.BatchingBatcher.checkRowCount(BatchingBatcher.java:93) at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:79) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:193) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:91) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:86) at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:169) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2162) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2117) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2373) at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:84) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:905) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:345) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at org.jbpm.bpel.service.messager.StartListener.onMessage(StartListener.java:123) at org.jboss.mq.SpyMessageConsumer.run(SpyMessageConsumer.java:707) at java.lang.Thread.run(Thread.java:595) 20:41:20,132 ERROR [StartListener] could not deliver request org.hibernate.StaleStateException: Batch update returned unexpected row count from update: 1 actual row count: 0 expected: 1 at org.hibernate.jdbc.BatchingBatcher.checkRowCount(BatchingBatcher.java:93) at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:79) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:193) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:91) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:86) at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:169) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2162) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2117) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2373) at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:84) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:905) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:345) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at org.jbpm.bpel.service.messager.StartListener.onMessage(StartListener.java:123) at org.jboss.mq.SpyMessageConsumer.run(SpyMessageConsumer.java:707) at java.lang.Thread.run(Thread.java:595) 20:41:20,422 INFO [DefaultLoadEventListener] Error performing load command org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [org.jbpm.graph.exe.Token#47] at org.hibernate.ObjectNotFoundException.throwIfNull(ObjectNotFoundException.java:27) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:128) at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:161) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:87) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:809) at org.hibernate.impl.SessionImpl.load(SessionImpl.java:731) at org.hibernate.impl.SessionImpl.load(SessionImpl.java:724) at org.jbpm.bpel.service.messager.RequestListener.onMessage(RequestListener.java:89) at org.jboss.mq.SpyMessageConsumer.run(SpyMessageConsumer.java:707) at java.lang.Thread.run(Thread.java:595) 20:41:20,422 ERROR [RequestListener] could not deliver request org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [org.jbpm.graph.exe.Token#47] at org.hibernate.ObjectNotFoundException.throwIfNull(ObjectNotFoundException.java:27) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:128) at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:161) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:87) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:809) at org.hibernate.impl.SessionImpl.load(SessionImpl.java:731) at org.hibernate.impl.SessionImpl.load(SessionImpl.java:724) at org.jbpm.bpel.service.messager.RequestListener.onMessage(RequestListener.java:89) at org.jboss.mq.SpyMessageConsumer.run(SpyMessageConsumer.java:707) at java.lang.Thread.run(Thread.java:595)
Thanks Joshua