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

[Mads Moelgaard Andersen]

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
[http://community.jboss.org/message/575321#575321]

Start a new discussion in EJB3 at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2029]

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