OracleConnectionCacheImpl Returns Wrong Active Connections Number After Closing Connections

(Doc ID 579672.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Containers for J2EE - Version: 10.1.2.2.0
This problem can occur on any platform.

Symptoms

An application is deployed into 10.2.2  Oracle Application server. This application is retrieving  JDBC connection from a native datasource via the  oracle.jdbc.pool.OracleConnectionCacheImpl class.

After getting a JDBC connection from this datasource, and  closing this connection, the status of the related  JDBC connection pool is not correct.  The number of active connections  is equal to the the size of the connection pool. After closing a JDBC connection, the expected result  is  that the number of active connections is less than the connection pool size.

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