How to Get Connection Properties List in OC4J Connection Pool Datasource Configuration ? (Doc ID 1934390.1)

Last updated on FEBRUARY 13, 2024

Applies to:

Goal

Refering to the
Oracle Containers for J2EE Services Guide
10g Release 3 (10.1.3)
B14427-01
Chapter 4 Data Sources
Section 4.6.3.2 Connection Properties

you can configure a connection pool with a list of connection properties  related to an Oracle JDBC Driver connection by using the <connection-properties> tag : 
" The <connection-properties> tag defines the connection properties that will be set on the connection factory when the connection factory
is an instance of oracle.jdbc.pool.OracleDataSource (including instances that are derived from oracle.jdbc.pool.OracleDataSource).
Each connection property is defined by the <property> sub-tag. There may be 0 - N <property> sub-tags defined for the <connection-properties> tag. "

To illustrate the connection-properties tag use, here is a sample where the connection property "oracle.jdbc.RetainV9LongBindBehavior"  is set  to "true" value  :

The list of the connection properties cannot be found in OC4J documentation.

The question is to know how to obtain  the list of connection properties that can be configured and their related descriptions.

Solution

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