My Oracle Support Banner

Connection Pool Starts Growing In Size After Migrating To UCP 19c (Doc ID 2853725.1)

Last updated on MARCH 11, 2022

Applies to:

Universal Connection Pool - Version 19.7 and later
Information in this document applies to any platform.

Symptoms

After migrating from a third party connection pool to using UCP , it is found that the connection pool is now steadily growing in size until the error "java.sql.SQLException: oracle.ucp.UniversalConnectionPoolException: All connections in the Universal Connection Pool are in use" is encountered.

Changes

 The expectation was that by using the property "AbandonConnectionTimeout" with a value of 120, the UCP will monitor the borrowed connections and reclaim them back into the connection pool after a connection has not been used for a specific amount of time.

The is causing the pool size to grow over time leading to the error.

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


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