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. This custom property is supported only in Oracle version 9.2.0.4 or later or version 10g.
 
Resolving the problem
The method used with datasources is to set a Custom Property in the datasource as follows:

Name: connectionProperties
Value: oracle.jdbc.V8Compatible=true

where oracle.jdbc.V8Compatible=true is an example Oracle JDBC driver property to be set.
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): Windows
Software version: 6.1
Software edition:
Reference #: 1197705
IBM Group: Software Group
Modified date: Mar 31, 2006