This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Tomcat
Bookmark "JDBC driver,Tomcat,DB2 Problem" Watch "JDBC driver,Tomcat,DB2 Problem" New topic
Author

JDBC driver,Tomcat,DB2 Problem

J You
Greenhorn

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:
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
conn = DriverManager.getConnection(
"jdbc:db2:BankDB",userid,passwd);
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
DB2.
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.
Thanks
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
:noJsse
set CLASSPATH=%CP%
*Replace the last line with*
set CLASSPATH=%CP%;%CLASSPATH%
Let me know if this works.
Ravi

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