IBM Support

Use"isolate the resource provider" to establish data source connections using a different JDBC driver from the same database vendor

Troubleshooting


Problem

Customer has defined 3 Oracle JDBC Providers at cell, node and server scope. Client have following configuration in websphere JDBC provider. In Cell Scope - C:\jdbc\ojdbc5\ojdbc5.jar In Node Scope - C:\jdbc\ojdbc6_g\ojdbc6_g.jar In Server Scope- C:\jdbc\ojdbc6\ojdbc6.jar In this case value of JDBC driver path in WebSphere variable is identical. Nornally, If JDBC provider configure at server level then server level driver will get load first. But in this case since all three drivers are from same vendor, So we can not control which driver is picking up. In this case "C:\jdbc\ojdbc6\ojdbc6.jar" should be loaded first but instated, ojdbc5.jar was load first [13. 4. 5 12:05:15:625 KST] 00000023 CompoundClass < loadClass oracle.jdbc.driver.OracleDriver loader=com.ibm.ws.bootstrap.ExtClassLoader@5dc95dc9 source=file:/C:/jdbc/ojdbc5/ojdbc5.jar Exit

Symptom

Due to multiple JDBC drivers from the same vendor were configured in different scopes, the wrong driver class was loaded.

[{"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"DB Connections\/Connection Pooling","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.0;8.5;8.0;7.0","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
WebSphere Application Server

Software version:
9.0, 8.5, 8.0, 7.0

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

Document number:
490043

Modified date:
03 March 2025

UID

swg21634612

Manage My Notification Subscriptions