Forcing batcher resource cleanup on transaction completion

[mariaprabudass]

Hi,

When we trying to complete the task using local human-task, I have found the below exception frequently. Could you please check and advise me.

Versions:-

JBoss:- jboss-as-7.0.2 Final

Hibenate:- 3.6.9

JBPM:-     5.2.0 Final

Exception:-

16:32:29,527 INFO  [org.hibernate.jdbc.ConnectionManager] (http--10.0.5.53-8080-2) forcing batcher resource cleanup on transaction completion; forgot to close ScrollableResults/Iterator?

16:32:29,531 WARNING [org.hibernate.util.JDBCExceptionReporter] (http--10.0.5.53-8080-1) SQL Error: 0, SQLState: null

16:32:29,533 SEVERE [org.hibernate.util.JDBCExceptionReporter] (http--10.0.5.53-8080-1) Connection handle has been closed and is unusable

Caused by: java.sql.SQLException: Connection handle has been closed and is unusable

  at org.jboss.jca.adapters.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:1589)

  at org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1566)

  at org.jboss.jca.adapters.jdbc.WrappedStatement.checkTransaction(WrappedStatement.java:1251)

  at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:453)

  at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) [hibernate-core-3.6.9.Final.jar:]

  at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) [hibernate-core-3.6.9.Final.jar:]

  at org.hibernate.loader.Loader.doQuery(Loader.java:802) [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.loadEntity(Loader.java:2037) [hibernate-core-3.6.9.Final.jar:]

  ... 95 more

Thanks & Regards,

Maria

[mariaprabudass]

Any update!. In addition, we have implemented LocalTaskService for Human Task. In that, when two user try to complete the different task in the same time, One is getting correct response and another is getting error response. Please find above mentioned jBoss server log for reference. We're really getting stuck with this. Kindly check and advise us..

Thanks for looking into this,

Maria