i have tomcat4 running with Oracle8i with jdk1.4. Because it is jdk 1.4, need to use the oracle9i drivers to access the oracle8i db. I use the following two drivers, obtained from Oracle, which work fine:
ojdbc14.jar ocrs12.jar i think your problem is more likely to do with server.xml, placement and/or content: do you define your contexts explicitly in your server.xml file? -paul. ----- Original Message ----- From: "John Sidney-Woollett" <[EMAIL PROTECTED]> To: "Jonathan Drnek" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, December 10, 2003 12:25 PM Subject: Re: Tomcat 5 and oracle > 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:@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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
