How to Get Connection Properties List in OC4J Connection Pool Datasource Configuration ?
Last updated on OCTOBER 02, 2017
Applies to:Oracle Containers for J2EE - Version 10.1.3.5.0 and later
Information in this document applies to any platform.
Refering to the
Oracle Containers for J2EE Services Guide
10g Release 3 (10.1.3)
Chapter 4 Data Sources
Section 126.96.36.199 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.
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