... Here's a thought. are the drivers for DB2 100% java native. I'm remembering a problem a colleage of mind had using the the jdbc drivers for a database named Progress. It turns out they were not 100% java and relied on calls to native libraries. If you're running on windows it'll be a dll or something.
<mike/> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 8:46 AM To: Tomcat Users List Subject: RE: Connection between TOMCAT and DB2 ??? Hello John, It was a nice thinking but I didn't worked. It is not finding the driver even now...I tried printing the classpath..though it shows the all 3 ".jar" files included but it is working only in %SQLLIB%\bin directory that is if I try to run my file by keeping it in %SQLLIB%\bin directory it worked fine and retieve resultsets from database but not from TOMCAT_HOME directory... Any other tries..? ------------------------------------------------------------------------------------ Nishant Awasthi Corporate Systems Development Progressive Insurance "Turner, John" To: 'Tomcat Users List' <JTurner@AAS. <[EMAIL PROTECTED]> com> cc: (bcc: Nishant Awasthi) Subject: RE: Connection between TOMCAT and 07/31/2002 DB2 ??? 09:27 AM Please respond to "Tomcat Users List" Try renaming your .zip files to .jar files. Just change the extension from .zip to .jar without changing the files themselves. John Turner [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 9:22 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Connection between TOMCAT and DB2 ??? Hello everyone... thanks for showing interest in the list and to make it grow... I have a situation here. I am using tomcat 4.0.3 and jdk 1.3.1_04. I want to write a soap service which will bring the resultset from IBM DB2 database. Before implementing soap I am writing a simple Java "Ndb2servlet.java" file inside %TOMCAT_HOME%\webapps\soap\WEB-INF\classes Now it compile fine but when I try to run it it says: >>>>> COMPILING >>C: \jakarta-tomcat-4.0.4\webapps\soap\WEB-INF\classes>javac Ndb2servlet.java >>>>> RUNNING >>C:\jakarta-tomcat-4.0.4\webapps\soap\WEB-INF\classes>java Ndb2servlet SQL Exception: No suitable driver I have tried to put db2java.zip, runtime.zip and sqlj.zip in %TOMCAT_HOME% \common\lib and and also included in system classpath then restarted TOMCAT but still it couldn't find driver. DO I need to do something special for my JAVA file in tomcat to find "DB2driver" Please help.... thanks ---------------------------------------------------------------------------- -------- Nishant Awasthi Corporate Systems Development Progressive Insurance -- 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]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
