If the JAR files are in TOMCAT_HOME/common/lib, and you get the No Suitable Driver error, there is something wrong with your connection string, or with how you are connecting, as someone else suggested.
I had the same exact problem with the SQL Server 2000 drivers (same error message) and after a couple of hours of trial and error realized that the connection string was wrong. By "connection string" I mean both the driverName and the driverURL. John Turner [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 10:53 AM To: Tomcat Users List Subject: Re: AW: Connection between TOMCAT and DB2 ??? Hello Ralph Thanks for your suggestion. I tried putting runtime.jar, db2java.jar and sqlj.jar files in %JAVA_HOME%/jre/lib/ext directory. and also in %TOMCAT_HOME%/common/lib directory and restarted TOMCAT but it still couldn't find the driver when I try to run the compiled java file it says No suitable driver Any other suggestions... ---------------------------------------------------------------------------- -------- Nishant Awasthi Corporate Systems Development Progressive Insurance "Ralph Einfeldt" <ralph.einfeldt@upti To: "Tomcat Users List" me-isc.de> <[EMAIL PROTECTED]> cc: (bcc: Nishant Awasthi) 07/31/2002 10:45 AM Subject: AW: Connection between TOMCAT and Please respond to DB2 ??? "Tomcat Users List" The only place outside the tomcat directories where tomcat will find additional jars is ${JAVA_HOME}/jre/lib/ext. If you can't place the jar file there you have to copy or link the file to a tomcat lib directory. Ralph Einfeldt; Uptime Internet Solution Center GmbH Hamburg, Germany Hosting, Content Management, Java Consulting http://www.uptime-isc.de > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Gesendet: Mittwoch, 31. Juli 2002 16:40 > An: Tomcat Users List > Betreff: RE: Connection between TOMCAT and DB2 ??? > > > But I cannot make the same file run from outside the DB2 > realm...that is when I place same java file in TOMCAT_HOME directory it > doesnot find the driver... > -- To unsubscribe, e-mail: < mailto:[EMAIL PROTECTED]> For additional commands, e-mail: < mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
