Concurrent access problem
nomad Jun 22, 2006 8:31 AMI have a Task node where a number of task instances are created and assigned to mulpile actors. Each of these actors has his/her own task list page where they can mark the task instance as finished. However whenever more than 1 actors trying to finish the task instances, only 1 actor can actually commit the data while others will just simply hit error
like this :
19:21:56,031 [Thread-1] ERROR AbstractFlushingEventListener : Could not synchronize database state with session org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [org.jbpm.graph.exe.Token#10168] at org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:1635) org.jbpm.persistence.JbpmPersistenceException: couldn't commit hibernate session at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:171) at org.jbpm.svc.Services.close(Services.java:211) at org.jbpm.JbpmContext.close(JbpmContext.java:138) at test.TestBPM$Executor.run(TestBPM.java:253)
or like this :
19:30:49,671 [Thread-0] ERROR JDBCExceptionReporter : ORA-00060: deadlock detected while waiting for resource 19:30:49,671 [Thread-0] ERROR AbstractFlushingEventListener : Could not synchronize database state with session org.hibernate.exception.GenericJDBCException: could not update: [org.jbpm.graph.exe.Token#10229] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2222) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2118) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2374) 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)
and sometimes, the program will just simply hang while trying to save the process as if it's waiting for something.
I really need help on this, please help....please...:(
Regards,
Martin