My Oracle Support Banner

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

Last updated on SEPTEMBER 13, 2023

Applies to:

Oracle Containers for J2EE - Version 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 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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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