Operation failed in LocalTaskService
We have implemented LocalTaskService in our Web App. I have been facing concurrency problem for the below scenario.
Scenario:
When two users are trying to complete the different task (on same time), exception occurs. This issue has not been noticed when the users complete task at different time. We're really getting stuck up with this. Is there any solution to this problem? Awaiting for your's valuable feedback.
Given below the version details,
jBPM - 5.4.0.Final
jBoss - 7.0.2.Final
Spring - 3.1.1.RELEASE
Hibernate - 3.6.9
Posted below the jBoss server log exception for your reference.
Exception1:-
[org.hibernate.jdbc.ConnectionManager] (http--localhost-8080-17) forcing batcher resource cleanup on transaction completion; forgot to close ScrollableResults/Iterator?
10:31:09,431 INFO [stdout] (http--localhost-8080-17) Exception..!
10:31:09,439 ERROR [stderr] (http--localhost-8080-17) java.lang.RuntimeException: Operation failed
10:31:09,440 ERROR [stderr] (http--localhost-8080-17) at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:1130)
10:31:09,440 ERROR [stderr] (http--localhost-8080-17) at org.jbpm.task.service.TaskServiceSession.getEntity(TaskServiceSession.java:1069)
10:31:09,441 ERROR [stderr] (http--localhost-8080-17) at org.jbpm.task.service.TaskServiceSession.getTask(TaskServiceSession.java:605)
10:31:09,441 ERROR [stderr] (http--localhost-8080-17) at org.jbpm.task.service.local.LocalTaskService.getTask(LocalTaskService.java:157)
Exception2:-
11:01:29,766 INFO [org.hibernate.jdbc.ConnectionManager] (http--localhost-8080-14) forcing batcher resource cleanup on transaction completion; forgot to close ScrollableResults/Iterator?
11:01:29,767 WARNING [org.hibernate.jdbc.AbstractBatcher] (http--localhost-8080-19) exception clearing maxRows/queryTimeout: java.sql.SQLException: Connection is not associated with a managed connection.org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6@2e63879b
at org.jboss.jca.adapters.jdbc.WrappedConnection.lock(WrappedConnection.java:151)
at org.jboss.jca.adapters.jdbc.WrappedStatement.lock(WrappedStatement.java:88)
at org.jboss.jca.adapters.jdbc.WrappedStatement.getMaxRows(WrappedStatement.java:515)
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:298) [hibernate-core-3.6.9.Final.jar:]
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:234) [hibernate-core-3.6.9.Final.jar:]
at org.hibernate.loader.Loader.doQuery(Loader.java:854) [hibernate-core-3.6.9.Final.jar:]
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) [hibernate-core-3.6.9.Final.jar:]
at org.hibernate.loader.Loader.loadCollection(Loader.java:2166) [hibernate-core-3.6.9.Final.jar:]
Thank for looking into this,
Maria Prabudass