Tomcat 5 and oracle

[Jonathan Drnek]

I am having a problem setting up a data source in tomcat.  I seem to remember having this problem last time I played with it several moths ago but I don’t remember what I did to fix it.   I am running Tomcat 5.0.16 with JVM version 1.4.2_03-b02 on windows 2000.   I am trying to connect to an Oracle 8.1.7.1.0 database.   I have placed the ojdbc14.jar file in common\lib   The error I am getting is   javax.servlet.ServletException: Cannot create JDBC driver of class '' for connect URL 'null', cause: No suitable driver   I am using oracle.jdbc.driver.OracleDriver because that’s what the docs said, but I seem to recall that was not correct.  I just can’t find anything that tells me what other driver I should be using.     My server.xml file has   . . . <Resource name="jdbc/ordt" type="javax.sql.DataSource"/> . . . </ResourceParams>   <ResourceParams name="jdbc/ordt">       <parameter>         <name>validationQuery</name>         <value>select * from dual</value>       </parameter>       <parameter>         <name>url</name>         <value>jdbc:oracle:thin:@holl302h:1521:ORDT</value>       </parameter>       <parameter>         <name>password</name>         <value>password</value>       </parameter>       <parameter>         <name>maxActive</name>         <value>4</value>       </parameter>       <parameter>         <name>maxWait</name>         <value>5000</value>       </parameter>       <parameter>         <name>driverClassName</name>         <value>oracle.jdbc.driver.OracleDriver</value>       </parameter>       <parameter>         <name>username</name>         <value>username</value>       </parameter>       <parameter>         <name>maxIdle</name>         <value>2</value>       </parameter> </ResourceParams> . . .   web.xml looks like   <?xml version="1.0" encoding="ISO-8859-1"?>   <!DOCTYPE web-app     PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"     "http://java.sun.com/dtd/web-app_2_3.dtd">   <web-app>   <display-name>Metrology Lab</display-name>   <description>      First Source Metrology Lab   </description>    <resource-ref>  <description>Oracle Datasource example</description>  <res-ref-name>jdbc/ordt</res-ref-name>  <res-type>javax.sql.DataSource</res-type>  <res-auth>Container</res-auth> </resource-ref>   </web-app>   my code looks like               Context initContext = new InitialContext();             Context envContext  = (Context)initContext.lookup("java:/comp/env");             DataSource ds = (DataSource)envContext.lookup("jdbc/ordt");             Connection conn = ds.getConnection();   Thanks for any help,   Jon Drnek

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]