I'm not running Tomcat 5.5 - in fact, I haven't even used my older Tomcat
setup (4.1.x) with DB2 V7 in quite a while and I haven't used it with DB2 V8
at all - but I use DB2 quite a bit with Java applications that I write so
perhaps I can help....
The old JDBC drivers are deprecated as of Version 8 of DB2. However, you can
still use them if you like. New Universal drivers are provided with Version
8 and should be located in db2jcc.jar. The URLs for the new drivers change
just a little bit but the new syntax is documented in the Information
Center.
The manuals suggest that you need all to have all three of the following
jars in your classpath:
- sqllib\java\db2java.zip
- sqllib\java\db2jcc.jar
- sqllib\java\db2jcc_license_cu.jar
I'm guessing that you *might* get away with using just db2java.zip if you're
sticking to the old drivers. However, it would be best to put all three jars
on your classpath so that you can use either the old or new drivers at any
time without having to install anything else later.
Also, you *may* need some additional jars, depending on what you are doing.
Rather than cutting and pasting chunks of the manual and maybe missing
something, let me suggest that you go to the Information Center and put
"Setting up the Windows Java Environment" in the Search box; if you press
Go, you should see the page I mean.
If this advice doesn't help, you will find an active DB2 newsgroup at
comp.databases.ibm-db2 on Usenet. It is monitored by the IBM Toronto lab,
which is responsible for DB2 on Unix/Linux/Windows, and they often jump in
to help with questions people post. If you ask there, you are almost certain
to get a good answer.
By the way, I don't think you need to rename db2java.zip to db2java.jar; in
fact, that may be the source of your problem. You may want to try renaming
it back to db2java.zip FIRST and see if that resolves the problem before
worrying about adding any additional jars.
For what it's worth, I think your db2java.zip file is in the right place -
tomcat_home\common\lib - but you may want to double-check the Tomcat docs;
they may have made some changes for Tomcat 5.x and 5.5.x.
Rhino
----- Original Message -----
From: "Jon Christensen" <[EMAIL PROTECTED]>
To: <users@tomcat.apache.org>
Sent: Tuesday, October 25, 2005 2:01 PM
Subject: DB2 and Tomcat 5.5 Issue
Has anyone been able to connect to a DB2 8.1 datasource using Tomcat 5.5?
I have been trying for a few days now and can only get one error message:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver
of class 'COM.ibm.db2.jdbc.app.DB2Driver' for connect URL
'jdbc:DB2:bfstst' at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSourc
e.java:780)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.j
ava:540)
Caused by: java.sql.SQLException: No suitable driver at
java.sql.DriverManager.getDriver(DriverManager.java:243)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSourc
e.java:773)
... 23 more
I've got the db2java.jar (renamed from db2java.zip) in
tomcat_home\common\lib and also in my web apps's lib directory.
We are trying to switch from using WSAD 5.x to using Eclipse and Tomcat
5.5 running under XP but this has been holding me up for quite some
time now. Any help would be greatly appreciated.
Thanks,
Jon
The information contained in this e-mail and any accompanying documents may
contain information that is confidential or otherwise protected from
disclosure. If you are not the intended recipient of this message, or if
this message has been addressed to you in error, please immediately alert
the sender by reply e-mail and then delete this message, including any
attachments. Any dissemination, distribution or other use of the contents of
this message by anyone other than the intended recipient is strictly
prohibited.
----------------------------------------------------------------------------
----
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.361 / Virus Database: 267.12.5/148 - Release Date: 25/10/2005
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.361 / Virus Database: 267.12.5/148 - Release Date: 25/10/2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
