have you tried with classes111.jar instead? cheers,
ralf -----Ursprüngliche Nachricht----- Von: Jonathan Drnek [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 10. Dezember 2003 16:59 An: Tomcat Users List Betreff: RE: Tomcat 5 and oracle I'm not sure how that got removed, but I put it back in and it did not help. I can do the following: DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@holl302h:1521:ORDT","ordl ine","junk"); So I assume that I have the right oracle drivers etc, I just don't have JNDI or dbcp setup right. Thanks for the suggestion -----Original Message----- From: Knight, Digby [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2003 10:10 AM To: [EMAIL PROTECTED] Subject: RE: Tomcat 5 and oracle You may need the following in your server.xml ResourceParams: <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> It's described in more detail in: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples -how to.html <http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-example s-ho wto.html> -----Original Message----- From: Jonathan Drnek [mailto:[EMAIL PROTECTED] Sent: 10 December 2003 14:37 To: [EMAIL PROTECTED] Subject: Tomcat 5 and oracle 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 ***************************************************************** The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). This information may be subject to legal professional or other privilege or may otherwise be protected by work product immunity or other legal rules. It must not be disclosed to any person without our authority. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are not authorised to and must not disclose, copy, distribute, or retain this message or any part of it. ***************************************************************** --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
