Try using the thin driver - it's jar file is classes12.jar

Place it in [TOMCAT_HOME]/common/lib

John Sidney-Woollett

Jonathan Drnek said:
> 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:@(protected)>
>     </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: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)