How to switch from jdbc driver 10.x to 9.x

I currently have the jdbc driver 10.x installed and I cannot get rid of it. I deleted every instance of ojdbc14.jar on the server. and I put classes12.jar in /$catalina_home/common/lib/ I stop tomcat restart apache and than start tomcat again. and every time a create a connection and run the following code:

DatabaseMetaData dmd = connection.getMetaData();

out.println("JDBC Driver version: " + dmd.getDriverVersion());

I get the following output:

JDBC Driver version: 10.1.0.3.0

please help me! :P thanks!

[544 byte] By [sims11tza] at [2007-10-3 4:28:30]
# 1
> I get the following output:> > JDBC Driver version: 10.1.0.3.0> Which is correct, I guess. Open the MANIFEST.MF inside the driver jar and check.
aniseeda at 2007-7-14 22:31:28 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
classes12.jar does not mean oracle 9, it used for jre 1.2, 1.3
masuda1967a at 2007-7-14 22:31:28 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3

> I currently have the jdbc driver 10.x installed and I

> cannot get rid of it. I deleted every instance of

> ojdbc14.jar on the server. and I put classes12.jar in

> /$catalina_home/common/lib/ I stop tomcat restart

> apache and than start tomcat again. and every time a

> create a connection and run the following code:

>

> DatabaseMetaData dmd = connection.getMetaData();

> out.println("JDBC Driver version: " +

> dmd.getDriverVersion());

>

> I get the following output:

>

> JDBC Driver version: 10.1.0.3.0

>

>

> please help me! :P thanks!

1. download the driver you want

2. put it somewhere

3. point your classpath to the driver or register the datasource using that jar

SoulTech2012a at 2007-7-14 22:31:28 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 4
And why would you want to use the 9i driver anyways? The 10.x JDBC driver works with 9i databases and is faster and more efficient.
Caffeine0001a at 2007-7-14 22:31:28 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 5
see if somebody put the 10g JAR in the /jre/lib/ext directory on the server. %
duffymoa at 2007-7-14 22:31:28 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 6
classes12.jar is a very old version of the Oracle JDBC driver. Where'd you get it?You can download any JDBC driver you want from this Oracle site: http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html%
duffymoa at 2007-7-14 22:31:28 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 7
"classes12.jar is a very old version of the Oracle JDBC driver"...that's not true.It's depending on version of java on the server.Both oracle 9 or 10 have classes12.jar for JRE 1.2, 1.3ojdbc14.jar is used for JRE 1.4 or later
masuda1967a at 2007-7-14 22:31:28 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 8
thanks for correcting me.%
duffymoa at 2007-7-14 22:31:28 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 9
I found out that hard way solving problem. :)
masuda1967a at 2007-7-14 22:31:28 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...