How to use oracle8i jdbc driver in jboss3.2.1?

[coolchen]

My project uses oracle8i as database and I use oracle8i jdbc driver from oracle8i client:class12.jar. When I run porject in jboss, it prints some errors:

18:09:34,049 ERROR [JDBCExceptionReporter] Apparently wrong driver class specified for URL: class: oracle.jdbc.driver.OracleDriver, url: jdbc:oracle:thin:@10.60
.2.8:1521:db129; - nested throwable: (org.jboss.resource.JBossResourceException:
Apparently wrong driver class specified for URL: class: oracle.jdbc.driver.OracleDriver, url: jdbc:oracle:thin:@10.60.2.8:1521:db129)

My question is how to use oracle8i jdbc instead of oracle9i jdbc for my project?

[alanmoor]

Make sure classes12.jar is available, most likely in {jbosshome}/server/default/lib.

Delete any other Oracle JDBC JAR files from JBoss - ojdbc14.jar for example.

Make sure a path similar to: C:\oracle\ora9\jdbc\lib\???.jar is not in your classpath.

Make sure there is one and only one classes12.jar in your classpath.

Obviously, there is a class conflict in that OracleDriver is found in two different places and JBoss quite correctly complains about it.

Good Luck