Enabling Implicit Connection Caching Using an OracleConnectionPoolDataSource Instance (Doc ID 375526.1)

Last updated on FEBRUARY 10, 2022

Applies to:

Goal

The following document outlines how one can use an OracleConnectionPoolDataSource with Implicit Connection Cache and how that is achieved. You cannot use OracleConnectionPoolDataSource to use the Implicit Connection Cache. OracleConnectionPoolDataSource is a connection factory (that creates PooledConnection objects) and is pooled by the Implicit Connection Cache. OracleDataSource is the only front end DataSource that allows access to the Implicit connection cache.

If you would like to set a specific OracleConnectionPoolDataSource for the Implicit connection cache to use, you must call setConnectionPoolDataSource on the OracleConnectionCacheManager.

void setConnectionPoolDataSource(String cacheName, ConnectionPoolDataSource ds)

Solution

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