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

    Forcing batcher resource cleanup on transaction completion

    mariaprabudass
    mariaprabudass Mar 31, 2015 7:14 AM

      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

        • 1. Re: Forcing batcher resource cleanup on transaction completion
          mariaprabudass
          mariaprabudass Apr 4, 2015 8:58 AM (in response to 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

            • Actions