wood burning stoves 2.0*
The moose likes Tomcat and the fly likes JDBC driver,Tomcat,DB2 Problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Tomcat
Bookmark "JDBC driver,Tomcat,DB2 Problem" Watch "JDBC driver,Tomcat,DB2 Problem" New topic

JDBC driver,Tomcat,DB2 Problem

J You

Joined: Jul 31, 2001
Posts: 29
Hi,I am trying to access DB2 with JDBC driver in the
tomcat3.3 server.Following is the code:
conn = DriverManager.getConnection(
I also include the db2java.zip in the CLASSPATH.
When I run a simple java application with above code
to test the database access,it works.But when I
use it in a servlet from Tomcat,I got the
ClassNotFoundException Error.It seems the server can
not get the driver.
I checked old posts in JavaRanch and still can not
get a clear solution.I also ran the usejdbc2.bat in
Any advice?
Do I need to install the DB2 client in the machine?
Right now the DB2 server,Tomcat server and all programs
are in the same Win2000 box.
Ravi Veera
Ranch Hand

Joined: Jun 23, 2001
Posts: 127
Are you using Tomcat 4.x. I had a similar problem when accessing my Access database. The problem is with the classpath settings.
Here is what I suggest you try out. In the bin directory you should see catalina.bat. Open it up. Under that you should see the following lines
rem ----- Set Up The Runtime Classpath ----------------------------------------
set CP=%CATALINA_HOME%\bin\bootstrap.jar;%JAVA_HOME%\lib\tools.jar
if "%JSSE_HOME%" == "" goto noJsse
set CP=%CP%;%JSSE_HOME%\lib\jcert.jar;%JSSE_HOME%\lib\jnet.jar;%JSSE_HOME%\lib\jsse.jar
*Replace the last line with*
Let me know if this works.

Mike Curwen
Ranch Hand

Joined: Feb 20, 2001
Posts: 3695

Try renaming the zip file to jar.

Reference this post: http://www.javaranch.com/ubb/Forum56/HTML/000041.html
I agree. Here's the link: http://aspose.com/file-tools
subject: JDBC driver,Tomcat,DB2 Problem
Similar Threads
JSP DB2 Driver WebSphere
JDBC driver,Tomcat,DB2 Problem
DB2 jdbc driver 6.2 on linux red Hat 7.2 it doesn't Work with Iplanet web server 6.0
Access to DB2 UDB thru JDBC
JDBC driver,Tomcat,DB2 Problem