File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Oracle/OAS and the fly likes [OAS] Change jdbc driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "[OAS] Change jdbc driver" Watch "[OAS] Change jdbc driver" New topic

[OAS] Change jdbc driver

Xavier Vanderstukken

Joined: Sep 08, 2004
Posts: 1
I need to use the latest jdbc driver for Oracle 10g. So I add ojdbc14.jar available on the Oracle website to my /WEB-INF/lib directory.
I also add the following orion-web.xml file to /WEb-INF

But when I do that :

in a sample jsp it says that the loaded jdbc driver was the one provided by Oracle with the application server.
However if I delete the jdbc driver of OAS and replaces it by the ojdbc14.jar I received an unknown field exception when I try to connect to the db
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1141

As far as I know, the name of the JDBC driver file is hard-coded in OC4J.
A "hack" (or "workaround", if you prefer :- ) would be to rename the "ojdbc14.jar" file to the file that OC4J recognizes: "classes12dms.jar", and then replace the actual "classes12dms.jar" file with your (renamed) "ojdbc14.jar" file. But I haven't done this myself, so I can't guarantee that it will work.

Why do you need the "ojdbc14.jar" JDBC driver? What does it have, that is not available in the "classes12dms.jar" driver? Perhaps the problem could be solved merely by upgrading your version of OC4J?

In case you are unaware, there are Oracle-related forums at Oracle's OTN Web site.

Good Luck,
Gareth Western
Ranch Hand

Joined: Apr 07, 2004
Posts: 45

I'm also highly interested in a solution to this problem. The reason for this is we would like to try out the latest jdbc drivers with oc4j, however, as noted, the older drivers have been hard-coded into the oc4j release. The Oracle forum doesn't seem to have a solution either :\
I agree. Here's the link:
subject: [OAS] Change jdbc driver
It's not a secret anymore!