My Oracle Support Banner

After Upgrading to OC4J, JDBC Pooled Connections are Created and Closed Continuously (Doc ID 781570.1)

Last updated on FEBRUARY 13, 2024

Applies to:

Oracle Containers for J2EE - Version to [Release AS10gR2]
Information in this document applies to any platform.
Not reproducible on OC4J
Fixed on OC4J


After upgrading from / to Oracle Application Server, OC4J creates and closes JDBC connections without using the connection pooling.

An application is retrieving  JDBC connection from an Emulated Datasource which is configured with min-connections and inactivity-timeout connection pool parameters.
The issue is that retrieved JDBC connections from the pool are immediately closed by OC4J instead of being pooled after their use. The inactivity timeout parameter has no effect.
As a consequence, the overall system performance goes down dramatically.  This issue can impact OC4J performance and OC4J has to be restarted from time-to-time due to lack of response.




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

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