While the article suggests editing the MANIFEST file in db2jcc4.jar, version 10.1 does not include this entry at all. Removing db2jcc4.jar solved my problem, so a solution in this case could also be to upgrade db2jcc4 from an older version to version 10.1, or if that is not possible, edit the manifest file as instructed.
Active6 months ago
The Fix Central application is identifying the fixes you selected. When your order is ready, the results will be displayed. Download db2jcc4 JAR files with dependency. Search JAR files by class name. Db2jcc from group com.ibm.db2.jcc (version db2jcc4) IBM Data Server Driver for JDBC and SQLJ is a pure-Java driver (Type 4) that supports the JDBC 4 specification. You can use this JDBC driver for Java applications that access the Db2® LUW database server.
When adding db2jcc4.jar to the system class path, Tomcat 8.0 raises a FileNotFoundException on a jar file that has no apparent reference to my project, pdq.jar.
I couldn't find it anywhere on my system or where it might come from, except through a search which turned up the answer below.
In this case, I have my CATALINA_HOME pointed to C:tomcat8.0apache-tomcat-8.0.41 and my project has the following maven dependency defined:
J E Carter II
J E Carter IIJ E Carter II
4 Answers
This might happen in the newer versions of Db2 jcc driver:
Beginning with version 4.16 of the IBM Data Server Driver for JDBC and SQLJ, which is shipped with Db2 10.5 on Linux, UNIX, or Windows operating systems, the MANIFEST.MF file for db2jcc4.jar contains a reference to pdq.jar.
IBM Support offers 2 options:
Resolving the problem To prevent the java.io.FileNotFoundException, you can take one of the following actions:
- Edit the MANIFEST.MF file, and remove this line: Class-Path: pdq.jar
- Edit the context.xml file for Apache Tomcat, and add an entry like the following one to set the value of scanClassPath to false.
Personally, I prefer the second approach, which can be done as following:
Kayvan TehraniKayvan Tehrani
2,04522 gold badges2121 silver badges3535 bronze badges
According to this KB article on IBM, the problem comes from the MANIFEST, which lists pdq.jar, a third party optimization tool.
Jar Download Software
I had both db2jcc4.jar and db2jcc4.10.1.jar in my lib folder.
While the article suggests editing the MANIFEST file in db2jcc4.jar, version 10.1 does not include this entry at all.
Removing db2jcc4.jar solved my problem, so a solution in this case could also be to upgrade db2jcc4 from an older version to version 10.1, or if that is not possible, edit the manifest file as instructed.
J E Carter IIJ E Carter II
You Just need to update jar db2jcc4.jar to be db2jcc4-10.1.jar
You can find maven dependency / Jar on that link
Ahmed SalemAhmed Salem
Kayvan Tehrani's answer explains what's going on here and that this error can be ignored.
Another alternative to clean up the logs is to create a dummy pdq.jar and place it into tomcat's lib folder.
(The ': no such file or directory' message from this command is expected.)
ClausClaus
Not the answer you're looking for? Browse other questions tagged javajdbc or ask your own question.
Active3 years, 8 months ago
Where do I download JDBC drivers for DB2 that are compatible with JDK 1.5? They seem to be very elusive and I hit many dead-ends at IBM's website. I managed to find versions of the driver bundled with some tools such as IBM Data Studio. Unfortunately, these versions either target a JVM too modern (JDK 1.6, leading to class version errors) or too ancient (JDK 1.2, leading to known bugs when run on JDK 1.5).
Adam PaynterDb2jcc4.jar Download Java2s
Adam Paynter38.3k2424 gold badges134134 silver badges157157 bronze badges
4 Answers
I know its late but i recently ran into this situation. After wasting entire day I finally found the solution. I am suprised that I got this info on oracle's website whereas this seems nowhere to be found on IBM's website.
If you want to use JDBC drivers for DB2 that are compatible with JDK 1.5 or 1.4 , you need to use the jar
Mustafa sabirMustafa sabirdb2jcc.jar
, which is available in SQLLIB/java/
folder of your db2 installation.3,37211 gold badge1010 silver badges2121 bronze badges
java acmjava acm
Right here: http://jt400.sourceforge.net/
This is what I use for that exact purpose.
EDIT: Usage Examples (minus exceptions):
Hope that helps!
BenColeBenCole1,69922 gold badges1414 silver badges2626 bronze badges
you can download and install db2client and looking for - db2jcc.jar - db2jcc_license_cisuz.jar - db2jcc_license_cu.jar - and etc.at C:Program Files (x86)IBMSQLLIBjava
Fuangwith S.Fuangwith S.3,62977 gold badges3232 silver badges3939 bronze badges