0 Replies Latest reply: Apr 23, 2013 1:10 AM by d3ni5 RSS

    DataSource fails if DB transaction exceeds Timeout and rollbacks

    d3ni5
      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