The IBM Data Server driver file is located within your Java™ class path. This driver package contains these two JAR files: db2jcc.jar db2jcc4.jar See the detailed system requirements document to obtain the most current information about the. The db2jcclicensecisuz.jar file is located in the /db2/license directory of the activation CD or activation file downloaded from Passport Advantage. The license files for DB2 Connect products are not shipped with fix packs. Fix packs only contain a 90 day trial license for DB2 Connect and do not contain the license for the JDBC driver.
- Java -cp./db2jcc.jar com.ibm.db2.jcc.DB2Jcc -version; The 'Build Number' indicates the date the driver was compiled and can be used to determine the drivers age. The build number naming convention is sYYMMDD, where YY is the year, MM is the month, and DD is the day. JDK/JRE 1.8 support first included with JDBC drivers bundled with v10.5 FP7.
- Both of them are DB2 JDBC driver jar files and are Type 4 drivers. Db2jcc.jar includes functions in the JDBC 3.0 and earlier specifications. If you plan to use those functions, include the db2jcc.jar in the application CLASSPATH.
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 Paynter4 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 db2jcc.jar, which is available in SQLLIB/java/ folder of your db2 installation.
Right here: http://jt400.sourceforge.net/
This is what I use for that exact purpose.
EDIT: Usage Examples (minus exceptions):
Hope that helps!
BenColeBenColeDb2 Jcc Driver
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.Not the answer you're looking for? Browse other questions tagged jdbcdb2 or ask your own question.
Troubleshooting
Problem
I'm trying to connect to a mainframe. I am new to JDBC connections. My java application fails with the following message. How do you locate or obtain the license jar file?'[jcc][t4][10109][10354][4.7.85] The version of the IBM Universal JDBC driver in use is not licensed for connectivity to xxx databases. To connect to this server, please obtain a licensed copy of the IBM DB2 Universal Driver for JDBC and SQLJ.An appropriate license file db2jcc_license_*.jar for this target platform must be installed to the application class path.Connectivity to xxx databases is enabled by any of the following files: [db2jcc_license_cisuz.jar]. ERRORCODE=-4472, SQLSTATE=42968'.
Cause
The JDBC connection checks to see if it is licensed to connect to the server by checking the CLASSPATH environment variable for db2jcc_license_cisuz.jar. If the correct license file is not listed in the CLASSPATH then the error is returned.
Resolving The Problem
To resolve the error you must add the appropriate DB2 JDBC license file to the applications CLASSPATH environment variable. If you are connecting to a host (z/OS or iSeries) then you need to add the db2jcc_license_cisuz.jar file.
Where do I find the license file?
The db2jcc_license_cisuz.jar file is included in all DB2 Connect server editions including DB2 Connect Personal Edition. The license is also part the IBM Database Enterprise Developer Edition. If you already have one of these products, then please use the license file from the DB2 Connect Activation CD. If you have a Passport Advantage account, then remember to download the activation key from Passport Advantage for the DB2 Connect edition that you have purchased.
The db2jcc_license_cisuz.jar file is located in the /db2/license directory of the activation CD or activation file downloaded from Passport Advantage.
The license files for DB2 Connect products are not shipped with fix packs. Fix packs only contain a 90 day trial license for DB2 Connect and do not contain the license for the JDBC driver. Only the purchased product delivered on physical media (CD or DVD) or delivered from Passport Advantage contains the JDBC license that allows you to connect to a mainframe.
I don't have a DB2 Connect product. Now what do I do?
If you do not have the file, then you must purchase a DB2 Connect product so that you may license the JDBC driver to connect to a mainframe.
Note: If the Java application is being ran as a deployed JAR file, the error can also be encountered if the Class-Path header field in the manifest file, MANIFEST.MF, does not include the path of db2jcc_license_cisuz.jar
https://www.ibm.com/developerworks/community/forums/html/topic?id=3dfe2446-ba9d-40d3-b519-3dc12f6da4b1
Related URL
Document Information
Ibm Db2 Jdbc Driver Download
Modified date:
23 June 2018