Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
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 8:10 PM by
DataSource fails if DB transaction exceeds Timeout and rollbacks
Apr 22, 2013 8:10 PM
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,
This content has been marked as final.
Show 0 replies