I assume you've checked the state of the ds object. Is it valid after you've gotten it from the lookup?
In other words cast down to an Object and perform getClass, etc. to determine it is a valid object. If it's not chances are your XML configuration is not good (server.xml or web.xml). Upon further review, you need an auth attribute on your Resource since you are using <resource-ref>. See http://jakarta.apache.org/tomcat/tomcat-5.0-doc/config/context.html#Resource %20Parameters "DBCP provides support for JDBC 2.0. On systems using a 1.4 JVM DBCP will support JDBC 3.0. Please let us know if you have used DBCP and its JDBC 3.0 features with a 1.4 JVM." --from Tomcat docs, sounds like 1.4 support may be a little shaky. You may want to try upgrading DBCP, collections, and pool jars in common/lib. The example mention in the docs for Oracle 8i also includes the factory as a parameter. See http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-how to.html#Database%20Connection%20Pool%20(DBCP)%20Configurations The classes12.jar only comes with Oracle 9 versions. The classes12.zip comes with Oracle 8.1.7 and earlier. You were correct to rename it, or extract and re-jar. -----Original Message----- From: Jonathan Drnek [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2003 1:11 PM To: Tomcat Users List Subject: RE: Tomcat 5 and oracle Classes12.zip didn't work either, even after I renamed it to classes12.jar Actually, DataSource ds = (DataSource)envContext.lookup("jdbc/ordt"); Connection conn = ds.getConnection(); Still didn't work and DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@holl302h:1521:ORDT","ordl ine","junk"); still did work. I am going to try and download a copy of the 1.2 jdk since that is what classes12 said it needed and try that. Any other suggestions? Jon -----Original Message----- From: Koes, Derrick [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2003 12:45 PM To: 'Tomcat Users List' Subject: RE: Tomcat 5 and oracle 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 --------------------------------------------------------------------- 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]
