This discussion is archived
0 Replies Latest reply: Apr 22, 2013 6:10 PM by d3ni5 RSS

DataSource fails if DB transaction exceeds Timeout and rollbacks

d3ni5 Newbie
Currently Being Moderated
Hello,

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:

Oracle 11.2.0.3
WLS 10.3.4
ojdbc6 11.2.0.2 and 11.2.0.3

Please help to resolve / workaround,

thank you

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points