actually, Oracle stated on their site that oracle.jdbc.driver.OracleDriver is deprecated and from versions 9i and on it's preferred to use oracle.jdbc.OracleDriver instead, but if Mohammed's truly relying on his localhost (127.0.0.1) for the Oracle connection, unless that's where his Oracle installation resides, I'd be a little suspect of that. In fact, I thought he provided the other day in an email a different URL and SID for Oracle.
And does he need the jar in three different places? I was thinking just in the CATALINA_HOME/lib, although I can't say for sure, I'm on the 4x series of TC, not 6.0. -----Original Message----- From: Christopher Schultz [mailto:[EMAIL PROTECTED] Sent: Friday, May 25, 2007 10:10 AM To: Tomcat Users List Cc: [EMAIL PROTECTED] Subject: Re: DBCP -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Mohammed, Mohammed Zabin wrote: > I put the jar file in my WEB-INF/lib and CATALINA_HOME/lib and CLASSPATH, > but nothing changed, I got the same error No, you are getting a different error. The first one was ClassNotFoundException. Now, you are getting: >>>> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create >>>> JDBC driver of class '' for connect URL 'null' Those are not the same. Search the archives for "Cannot create JDBC driver of class ''" and I'm sure you'll find this question answered hundreds of times over. It usually turns out to be an incorrect JDBC URL or an incorrect driver class name. Please check these over /carefully/: >>>> driverClassName="oracle.jdbc.OracleDriver" >>>> url="jdbc:oracle:thin:@127.0.0.1:1521:orcldb" For instance, I usually see "oracle.jdbc.driver.OracleDriver" instead of what you have above. - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGVvxA9CaO5/Lv0PARArmAAJsEdBWX6X0TcjTLZ30hFYNjACEAZQCgr9+d 7ag9qjj7Q+Uxg23E0P21XyU= =EAkm -----END PGP SIGNATURE----- --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
