[jboss-user] [EJB3] - Re: Entity Manager with BMT and Transaction Timeout

Mads Moelgaard Andersen do-not-reply at jboss.com
Fri Dec 10 01:29:04 EST 2010

Mads Moelgaard Andersen [http://community.jboss.org/people/mda_dk] created the discussion

"Re: Entity Manager with BMT and Transaction Timeout"

To view the discussion, visit: http://community.jboss.org/message/575321#575321

Hi Alexander

Did you ever get an answer to your question?

I have been facing a similar problem. We have an MDB without transaction support that calls a SLSB with BMT. For a long time we've been struggling with the SLSB just seeming to stop execution without throwing any exceptions or otherwise indicating an error. The method called on the SLSB results in sql that last for more than an hour.

At first we had JDBC transactions handle the commit and it seemed to work for the sql but for some reason the SLSB just seemed to stop its execution. Then we read a post indicating that JDBC transacdtions weren't that reliable and this would certainly account for a driver deciding to close a connection without a warning. Consequently we switched to JTA

Althout we programatically set TransactionTimeout to zero, equalling no timeout; on commit we caught arjuna exception indicating the connection to be inactive. After fiddling with the global JTA and setting it to 7200 seconds the long running sql statement executes and commits without exceptions.

This strongly suggests that the global transaction timeout in jboss-service.xml not only sets the default timeout for all JTA transactions also sets the value as the upper limit for all JTA transactions, regardless of what has been programatically set.

There must be someone out there that knows the truth  :)  and I would very much like to know what's right and wrong to this matter.

Best regards
Mads M Andersen

Reply to this message by going to Community

Start a new discussion in EJB3 at Community

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20101210/eccc340b/attachment.html 

More information about the jboss-user mailing list