Active6 months ago
Db2jcc.jar - This driver is based on the JDBC 3 specification; db2jcc4.jar - This driver is based on the JDBC 4 or later specifications; The db2jcc.jar driver is now deprecated. After version 3.72, which is delivered with DB2 Version 11.1 for Linux, UNIX, and Windows Mod 1 Fix Pack 1, db2jcc.jar will include no new features. The link you posted will get you the JCC driver, if you click on one of the version numbers it will take you to Fix Central where you can download the driver. POM was created from install:install-file. Date (Dec 14, 2008) Files: pom (252 bytes) jar (1.9 MB) View. Note: this artifact it located at OSGeo.
Db2jcc4.jar Db2 Download
Important: This step is performed automatically only for the db2jcc.jar and sqlj.zip file. If you are using the db2jcc4.jar file or the sqlj4.zip file, you must modify the CLASSPATH manually. Change db2jcc.jar to db2jcc4.jar or sqlj.zip to sqlj4.zip in the CLASSPATH. You also need to make this change in every DB2 command line window that you open.
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 Tehrani2,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.
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.
Aug 29, 2016Ā McAfee VirusScan Enterprise protects your desktop and file servers from a wide range of threats, including viruses, worms, Trojan horses, and potentially unwanted code and programs. McAfee VirusScanĀ® 8 takes anti-virus protection to the next level, integrating elements of intrusion prevention and firewall technology into a single solution for PCs and file servers. Download vse 8.8 patch 8. Hi, I have McAfee VSE 8.8 patch 4 installed in one of the Server. I would like to Update McAfee VSE 8.8 patch 4 to Patch 8. In forums I came across mention that 'VSE880P8.ZIP' contains Patch 8 however I couldn't locate a download link for the same.
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 PaynterAdam 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 sabirdb2jcc.jar
, which is available in SQLLIB/java/
folder of your db2 installation.Db2jcc4 License Cruz.jar Download
Mustafa sabir3,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 Best free sound recorder for windows 10.
Fuangwith S.Fuangwith S.3,62977 gold badges3232 silver badges3939 bronze badges