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

Last updated on AUGUST 03, 2016

Applies to:

JDBC - Version 10.1.0 to 10.2.0.4
Information in this document applies to any platform.

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

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