Defined two datasources to use two different JDBC drivers, but both datasources are using the same JDBC driver
 Technote (FAQ)
 
Problem
Defined a JDBC provider to use driver for Oracle 8.1.7.4 and another JDBC provider to use Oracle 9.2.0.5. Then defined two datasource's, one using each. Log files show that both datasources are using the Oracle 8.1.7.4 driver.
 
Cause
The different versions of the Oracle driver have the same jar filename (classes12.jar) and classnames. When classes get loaded into the JVM, only 1 set is loaded. When the Datasource calls a class, it picks up whatever class is already loaded in the JVM. This is working as designed.
 
Solution
Since most drivers are backward compatible, the later driver should be used.
 
 
Historical Number
55997
660
706
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Classloader
Operating system(s): AIX
Software version: 6.0
Software edition:
Reference #: 1200379
IBM Group: Software Group
Modified date: Mar 11, 2005