6 Replies Latest reply on Apr 10, 2009 9:26 AM by Dean Pullen

    Transaction is not active during large DB activity process

    Dean Pullen Novice

      Hi all,

      We've had this problem for a little while, but usually worked around it.
      It's time we understood it a bit more instead of continously fudging our code to work around the problem.

      Say we have 1 transaction. Within this transaction we're uploading a file with several thousand records.

      Each record causes several DB look ups *each*, using standard EJB3 Entity beans each within their own EAO Session bean.

      After all of this each row is then persisted as it represents an entity.


      During the process, sometimes, but not always, we get:

      ERROR org.hibernate.util.JDBCExceptionReporter - Transaction is not active: tx=TransactionImple < ac, BasicAction: 7f000002:95b7:49dcd694:8ff status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: 7f000002:95b7:49dcd694:8ff status: ActionStatus.ABORT_ONLY >)

      This error will repeat indefinitely until JBoss is shut-down.

      We're at a loss as to what's causing this. Transaction time-out is set to 20 mins at the moment, and this can happen 5 mins after submission.

      Also, no transaction roll back exception appears (no exception is shown in the logs) to be thrown during the process.

      Any help, advice, or pointers, would be appreciated.

      Regards,

      Dean.