1 Reply Latest reply on Apr 4, 2015 8:58 AM by mariaprabudass Edwin

    Forcing batcher resource cleanup on transaction completion

    mariaprabudass Edwin Newbie

      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