GO DIRECTLY TO
My Oracle Support Community
Oracle Technology Network
WebLogic Server - EJB
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Apr 22, 2013 6:10 PM by d3ni5
DataSource fails if DB transaction exceeds Timeout and rollbacks
Apr 22, 2013 6:10 PM
Currently Being Moderated
if XA transaction runs in database longer than timeout it rollbacks - and it's expected behavior.
But at the same time the DataSource marked as invalid and I no longer can get any connection from this datasource - its failing with:
java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_RMFAIL start() failed on resource 'jdbc/*********': XAER_RMFAIL : Resource manager is unavailable
My expectation that Datasource should not fail just because the database exceeded timeout - it should gracefully rollback.
I created isolated testcase and this behavior 100% reproducible on the following stack:
ojdbc6 188.8.131.52 and 184.108.40.206
Please help to resolve / workaround,
Track in Communications
- 10 points
- 5 points