My Oracle Support Banner

Connection.isValid Incorrectly Returns TRUE For Invalid Connections in UCP (Doc ID 1574473.1)

Last updated on AUGUST 30, 2023

Applies to:

Universal Connection Pool - Version 11.1.1.7.0 to 11.2.0.3.0 [Release Oracle11g to 11.2]
Information in this document applies to any platform.

Symptoms

A java application testing the vailidity of a connection using Connection.isValid, incorrectly gets "TRUE" for invalid connections after a RAC node failure.
The java application uses the Oracle Universal Connection Pool (UCP) with Fast Connection Failover (FCF) enabled. 
When a RAC node fails, the java application attempts to test the validity of a borrowed connection from the failed node and gets an incorrect result of "TRUE" from Connection.isValid. This happens when FCF is enabled.  Without FCF, Connection.isValid works correctly and returns "FALSE" for invalid connections.

Changes

 

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
Changes
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.