Re: Problem with JDBC-Connection to DB2 from Tomcat4.0.1
Hi Remy, the problem with the driver is solved. I have changed catalina.bat (set the Tomcat-CLASSPATH to the original driver-directory) and now the driver is found. Thank you for your help Anja Falkner -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Problem with JDBC-Connection to DB2 from Tomcat4.0.1
Hello list, is there anyone, who has an idea or can explain me the following situation: My JSP-file imports a self-written class named 'Connect'. This class should connect to DB2 with using IBM-app-driver. If I start this application, I get a ClassNotFoundException because of the driver. I have tried, to copy the driver to the local directory and the WEB-INF\classes\-directory. Then Tomcat says: Can't find bundle for base name... BUT: My pure java-program 'Connect.java' on the same computer can connect to DB2 without problems. It uses the same driver as the Tomcat-Application. Is it possible, that Tomcat doesn't use the same CLASSPATH as the system? And if, how can I say Tomcat, where he can find the driver? Many greetings Anja Falkner
RE: Problem with JDBC-Connection to DB2 from Tomcat4.0.1
set the driver name along with the path in the classpath eg is the driver name is abc.xyz in the folder d:\apache\...\web-inf then set the classpath to d:\apache\...\web-inf\abc.xyz this should work. Sumit. -Original Message- From: Anja Falkner [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 4:06 PM To: [EMAIL PROTECTED] Subject: Problem with JDBC-Connection to DB2 from Tomcat4.0.1 Hello list, is there anyone, who has an idea or can explain me the following situation: My JSP-file imports a self-written class named 'Connect'. This class should connect to DB2 with using IBM-app-driver. If I start this application, I get a ClassNotFoundException because of the driver. I have tried, to copy the driver to the local directory and the WEB-INF\classes\-directory. Then Tomcat says: Can't find bundle for base name... BUT: My pure java-program 'Connect.java' on the same computer can connect to DB2 without problems. It uses the same driver as the Tomcat-Application. Is it possible, that Tomcat doesn't use the same CLASSPATH as the system? And if, how can I say Tomcat, where he can find the driver? Many greetings Anja Falkner The information contained in this e-mail and any files transmitted with it may be privileged and confidential. If the reader of this message, regardless of the address or routing, is not an intended recipient, you are hereby notified that you have received this transmittal in error and any review, use, distribution, dissemination or copying is strictly prohibited. If you have received this message in error, please delete this e-mail and all files transmitted with it from your system and notify the sender by reply e-mail or by calling 1-888-338-6076. -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: Problem with JDBC-Connection to DB2 from Tomcat4.0.1
-Original Message- From: Anja Falkner [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 4:06 PM To: [EMAIL PROTECTED] Subject: Problem with JDBC-Connection to DB2 from Tomcat4.0.1 Hello list, is there anyone, who has an idea or can explain me the following situation: My JSP-file imports a self-written class named 'Connect'. This class should connect to DB2 with using IBM-app-driver. If I start this application, I get a ClassNotFoundException because of the driver. I have tried, to copy the driver to the local directory and the WEB-INF\classes\-directory. Then Tomcat says: Can't find bundle for base name... BUT: My pure java-program 'Connect.java' on the same computer can connect to DB2 without problems. It uses the same driver as the Tomcat-Application. Is it possible, that Tomcat doesn't use the same CLASSPATH as the system? And if, how can I say Tomcat, where he can find the driver? Its not only possible, its a blessing. The number of problems from CLASSPATH problems that were posted on this list has dropped to almost nothing. You have three options: 1. Place the Driver's jar file (or on UNIX use a symbolic link) in your webapp's WEB-INF/lib directory for JAR Files WEB-INF/classes for plain class files. 2. Place the Driver's jar file in TOMCAT_HOME/lib/apps if the JAR file needs to be shared by all web apps 3. Modify the tomcat.sh/.bat file in the TOMCAT_HOME/bin directory. NOTE: This method is unsupported and if you do it, you will mess things up, especially since you had to ask this question. Randy Many greetings Anja Falkner -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Problem with JDBC-Connection to DB2 from Tomcat4.0.1
hi, COpy the jar file of the JDBC driver, into lib directory of your server or web-inf lib directory of your application, then restart it, tomcat does not look into the system classpath as far as i know, i always copy the jar files in the lib directory of tomcat and all the classes need into the web-inf classes directory of the application. Hope this helps --- Anja Falkner [EMAIL PROTECTED] wrote: Hello list, is there anyone, who has an idea or can explain me the following situation: My JSP-file imports a self-written class named 'Connect'. This class should connect to DB2 with using IBM-app-driver. If I start this application, I get a ClassNotFoundException because of the driver. I have tried, to copy the driver to the local directory and the WEB-INF\classes\-directory. Then Tomcat says: Can't find bundle for base name... BUT: My pure java-program 'Connect.java' on the same computer can connect to DB2 without problems. It uses the same driver as the Tomcat-Application. Is it possible, that Tomcat doesn't use the same CLASSPATH as the system? And if, how can I say Tomcat, where he can find the driver? Many greetings Anja Falkner __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: RE: Problem with JDBC-Connection to DB2 from Tomcat4.0.1
Hi Randy, I have decided to change catalina.bat and it works!!! Thank you very much for your fast help! Anja -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Problem with JDBC-Connection to DB2 from Tomcat4.0.1
The answer to this is always the same, the class is not where your application is looking. So, that is the correct answer. Without knowing more about your situation, it is hard to tell what that means. Find out where the application is looking for the driver. The driver is not there. Put it there. Case closed. That is my experience over and over and over, etc. Hope this is not too clever and is meant to be helpful. At 09:05 PM 1/25/02 +, you wrote: Hello list, is there anyone, who has an idea or can explain me the following situation: My JSP-file imports a self-written class named 'Connect'. This class should connect to DB2 with using IBM-app-driver. If I start this application, I get a ClassNotFoundException because of the driver. I have tried, to copy the driver to the local directory and the WEB-INF\classes\-directory. Then Tomcat says: Can't find bundle for base name... BUT: My pure java-program 'Connect.java' on the same computer can connect to DB2 without problems. It uses the same driver as the Tomcat-Application. Is it possible, that Tomcat doesn't use the same CLASSPATH as the system? And if, how can I say Tomcat, where he can find the driver? Many greetings Anja Falkner -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Problem with JDBC-Connection to DB2 from Tomcat4.0.1
The answer to this is always the same, the class is not where your application is looking. So, that is the correct answer. Without knowing more about your situation, it is hard to tell what that means. Find out where the application is looking for the driver. The driver is not there. Put it there. Case closed. That is my experience over and over and over, etc. Hope this is not too clever and is meant to be helpful. At 09:05 PM 1/25/02 +, you wrote: Hello list, is there anyone, who has an idea or can explain me the following situation: My JSP-file imports a self-written class named 'Connect'. This class should connect to DB2 with using IBM-app-driver. If I start this application, I get a ClassNotFoundException because of the driver. I have tried, to copy the driver to the local directory and the WEB-INF\classes\-directory. Then Tomcat says: Can't find bundle for base name... BUT: My pure java-program 'Connect.java' on the same computer can connect to DB2 without problems. It uses the same driver as the Tomcat-Application. Is it possible, that Tomcat doesn't use the same CLASSPATH as the system? And if, how can I say Tomcat, where he can find the driver? Bug 5881 seems similar to this problem. The problems was caused because the DB2 driver used was JDBC 1.0 compliant. Tomcat needs a JDBC 2.0 driver and the driver included in DB 2 7.2 SP5 (maybe another version would be ok too) would fix the problem. Remy -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
