Datasource Declared Unhealthy After Transaction Timeouts And Thus Refusing Any Further Calls Using XA
Last updated on NOVEMBER 05, 2016
Applies to:Oracle WebLogic Server - Version 10.3.4 to 18.104.22.168
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
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