My Oracle Support Banner

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

Last updated on JUNE 17, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.