Datasource Declared Unhealthy After Transaction Timeouts And Thus Refusing Any Further Calls Using XA
(Doc ID 1481356.1)
Last updated on MARCH 12, 2021
Applies to:Oracle WebLogic Server - Version 10.3.4 to 126.96.36.199
Information in this document applies to any platform.
***Checked for relevance on 10-Mar-2016***
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
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