[OAS] Change jdbc driver

[Xavier Vanderstukken]

Hello,
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

 <?xml version="1.0"?>
<!DOCTYPE orion-web-app PUBLIC "-//ORACLE//DTD OC4J Web Application 9.04//EN" "http://xmlns.oracle.com/ias/dtds/orion-web-9_04.dtd">
 
<orion-web-app
        deployment-version="9.0.4.0.0"
        temporary-directory="./temp"
        internationalize-resources="false"
        default-mime-type="application/octet-stream"
>
                <web-app-class-loader search-local-classes-first="true"  include-war-manifest-class-path="true" />
</orion-web-app>

But when I do that :

<%@page language="java" %>
 
<%=Class.forName(request.getParameter("class1")).getResource(request.getParameter("class2")).toString()%>
  

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]

Xavier,
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,
Avi.

[Gareth Western]

Hi,

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 :\