I'm not 100% certain, but does Oracle even offer an 8.1.7/JDK 1.4 ojdbc14.jar file? I think it is only offered for 9.2. You are stuck with classes12.zip. I would try that. The common/lib directory is the correct place.
http://otn.oracle.com/software/tech/java/sqlj_jdbc/htdocs/jdbc817.html -----Original Message----- From: John Sidney-Woollett [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2003 12:25 PM To: Jonathan Drnek Cc: [EMAIL PROTECTED] 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] This electronic transmission is strictly confidential to Smith & Nephew and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, or someone authorized by the intended addressee to receive transmissions on behalf of the addressee, you must not retain, disclose in any form, copy or take any action in reliance on this transmission. If you have received this transmission in error, please notify the sender as soon as possible and destroy this message. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
