IBM Support

Using Oracle JDBC driver specific properties through a datasource

Technote (troubleshooting)


Problem(Abstract)

Properties directly supported by the Oracle JDBC driver that are not part of the JDBC specification cannot be used as a Custom Property in a datasource.

Cause

The Oracle JDBC driver has added support for a new Custom Property under connectionProperties..

Resolving the problem

The method used with datasources is to set a Custom Property in the datasource as follows:

Name: connectionProperties
Value: propertyA=valueA;propertyB=valueB


For example, if you wish to set the property oracle.jdbc.V8Compatible=true, then you would specify the following.
Name: connectionProperties
Value: oracle.jdbc.V8Compatible=true


Cross reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK

Document information

More support for: WebSphere Application Server
DB Connections/Connection Pooling

Software version: 7.0, 8.0, 8.5.5, 9.0

Operating system(s): AIX, HP-UX, IBM i, Linux, Solaris, Windows

Software edition: Base, Network Deployment

Reference #: 1197705

Modified date: 30 August 2012


Translate this page: