jQuery in Action, 3rd edition
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 REST with Spring (video course) this week in the Spring 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
It's not a secret anymore!