IBM Support

Using Oracle JDBC driver specific properties through a datasource

Troubleshooting


Problem

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

[{"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"DB Connections\/Connection Pooling","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF012","label":"IBM i"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.0;8.5.5;8.0;7.0","Edition":"Base;Network Deployment","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSNVBF","label":"Runtimes for Java Technology"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Java SDK","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
15 June 2018

UID

swg21197705