Datasource Declared Unhealthy After Transaction Timeouts And Thus Refusing Any Further Calls Using XA (Doc ID 1481356.1)

Last updated on NOVEMBER 05, 2016

Applies to:

Oracle WebLogic Server - Version 10.3.4 to 12.1.1.0
Information in this document applies to any platform.
***Checked for relevance on 10-Mar-2016***

Symptoms

A WLS 10.3.4+ datasource connection is returned to the pool but has an invalid state after the second timeout, which we can see in the log after the third call was done. We get the error SQLException Ocurred:Invalid or Stale Connection found in the Connection. It looks like the root of the problem is that when our call is timed out, the connection is returned to pool with some inappropriate state.

Future calls in WLS 10.3.2 and WLS 10.3.3 are responded to appropriately. In WLS 10.3.4 and higher, after 1 or 2 transaction timeouts using an XA datasource, subsequently all the requests fail with SQLException Ocurred:Invalid or Stale Connection found in the Connection Cache

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms