I am working on J2EE project that I am trying to deploy on weblogic8.1 and 9.2 servers;
this project supports multi-database vendors, oracle is one of the supported databases.
In this project we use the following oracle jdbc driver by placing it�s jar file into WEB-INF\lib folder of our web application
�Specification-Title: "Oracle JDBC driver classes for use with JDK1.4"
Specification-Version: "Oracle JDBC Driver version - 188.8.131.52.0"
Specification-Vendor: "Oracle Corporation" .
Implementation-Version: "Oracle JDBC Driver version - 184.108.40.206.0"
Implementation-Vendor: "Oracle Corporation"
Implementation-Time: "Thu Apr 25 23:14:02 2002"�
My problem is as follows:
Weblogic server 8.1 and 9.2 uses the following oracle jdbc driver by default
Specification-Title: Oracle JDBC driver classes for use with JDK14
Created-By: 1.4.2_08 (Sun Microsystems Inc.)
Specification-Vendor: Oracle Corporation
Specification-Version: Oracle JDBC Driver version - "10.2.0.2.0"
Implementation-Version: Oracle JDBC Driver version - "10.2.0.2.0"
Implementation-Vendor: Oracle Corporation
Implementation-Time: Tue Jan 24 08:55:21 2006
the driver I am using in my project which is 9.0.2 reads dates from database as java.sql.Timestamp objects
but the bundled 10g jdbc driver reads dates as java.sql.Date objects which make my code not to run and throws ClassCastException exceptions.
I want to figure how to make my application uses the ojdbc driver in the WEB-INF/lib folder, as I know from J2EE specs
every web application has it's own classloader that loads classes by order and it starts loading from the WEB-INF/lib folder. but
it seems loading the 10g driver classes first.
I can make a work around by creating managed server and modify the startWLS.cmd file by adding the jar file I want in front of the classpath
but this may be not applicable for customers who do not want to create a new managed server! also I have customers who have other third party
application which run using oracle 10g driver and the customer wants these applications to still using the weblogic OTB 10g driver.
What I want exactly, how to make a specific web application deployed on Weblogic server uses a specific driver jar file without affecting the server
classpath or any other third part applications deployed on the same server instance.