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

Last updated on MAY 02, 2016

Applies to:

Oracle Containers for J2EE - Version 10.1.3.5.0 and later
Information in this document applies to any platform.

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

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