Integrating DB2 license in standalone JAR application
I have developed a small utility for reading database tables and I'm trying to access DB2 tables. I am using DB2 for z/OS and my application is a standalone JAR file that you have to execute in command line using
java -jar. Also, I have the
db2jcc_license_cu.jar license that I received from a DBA. I already tried to pack this license in my JAR application, but I always get this error:
[jcc][t4][4.21.29] Connection to the data server failed. The IBM Data Server for JDBC and SQLJ license was invalid or was not activated for the DB2 for z/OS subsystem. If you are connecting directly to the data server and using DB2 Connect Unlimited Edition for System z, perform the activation step by running the activation program in the license activation kit. If you are using any other edition of DB2 Connect, obtain the license file, db2jcc_license_cisuz.jar, from the license activation kit, and follow the installation directions to include the license file in the class path. ERRORCODE=-4230, SQLSTATE=42968
The connection url is
jdbc:db2://<server>:<port>/<schema_name>:progressiveStreaming=2; which should be a Type 4 connection. I am using the Universal DB2 Driver. I don't know if including license jar is sufficient to make things work or if I need something more, like loading license or similar operations.
Any help will be appreciated.
As far as I remember,
db2jcc_license_cu.jar needs to be on the classpath of the application in order for the JDBC driver to pick it up.
As you are starting your application with
java -jar ... you can't specify additional jarfiles on the command line.
So you have two options:
db2jcc_license_cu.jarin your MANIFEST.MF when you build your application's jar file. Then you need to drop it into the same place as the other jar files referenced in the manifest.
Start your application specifying all jars using the
java -cp yourjar.jar;db2jcc4.jar;db2jcc_license_cu.jar your.main.Class
Note that the above example uses the Windows path separator. If you run your application on Linux you need to use
: instead of
DB2 for z/OS and WebSphere Integration for Enterprise Java , DB2. This section shows a simple Java stand-alone application. It shows the the IBM DB2 Driver for JDBC and SQLJ (db2jcc4.jar), the license JAR for the where db2install_path is the Db2 installation path, <license_path> is the full path name for the license file, and db2baf.lic is the license certificate file of IBM Db2 BLU Acceleration In-Memory Offering.
If you are using Eclipse IDE, it includes a facility that builds a project as a single JAR file (Export as Runnable JAR):
How to create a jar with external libraries included in Eclipse?
DB2 JDBC driver is not licensed for connectivity by file , An appropriate license file db2jcc_license_*.jar for this target platform must be installed to the application class path. Connectivity to xxx 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.
i passed 4 hours trying to do that, and finally i use jt400.rar and it works fantastic!
Installing the DB2 JDBC driver and license JARs, Before installing the JDBC JARs, ensure the Tivoli® Integrated Portal (TIP) service is stopped. To install the DB2® JDBC Driver and License JARs, copy the required JARs from the source directory C:\Program Files\IBM\SQLLIB\java Copy. db2jcc.jar or db2jcc4.jar Contains all JDBC classes and the SQLJ runtime classes for the IBM Data Server Driver for JDBC and SQLJ. Include db2jcc.jar in the CLASSPATH if you plan to use the version of the IBM Data Server Driver for JDBC and SQLJ that includes only JDBC 3.0 and earlier functions.
[PDF] Developing Enterprise Java Applications Using DB2 Version 8, A DB2 Connect™ Version 8 license/installation is required to access. DB2 for OS/390 To use the JDBC Universal Driver, the db2jcc.jar must be included in the Java. CLASSPATH The DB2 Development Center provides a standalone environment environments, from Java™ development to application integration. Before you install the IBM Data Server Driver for JDBC and SQLJ, you need the following software.. An SDK for Java™, 1.4.2 or later. For all Db2 products except the IBM Data Server Runtime Client and the IBM Data Server Driver Package, the Db2 on Linux, UNIX, and Windows systems installation process automatically installs the SDK for Java, Version 5.
DB2 JDBC lisence error, An appropriate license file db2jcc_license_.jar for this target platform SAP Process Integration See table 2 in the document "Supported stand-alone Java application development software" under the following address:. This IBM® Redbook is the second redbook in a series of two about Java™ stand-alone applications on z/OS®. We recommend using this document as a complement to Java stand-alone Applications on z/OS Volume I, SG24-7177. This book explains some topics discussed in Volume 1 in more depth, and also provides information about additional topics.
Newcomers » Accessing db2 from , I put the needed db2 jars(db2jcc.jar,db2jcc_license_cu.jar) in build path of the project folder.This is working fine(populating the data from db) when i run as standalone application. when we export our project com.ibm.db2.jcc.licenses, Eclipse IOTA Trinity, Swordfish, Maven Integration (M2E), Koneki If you are using any other edition of DB2 Connect, obtain the license file, db2jcc_license_cisuz.jar, from the license activation kit, and follow the installation directions to include the license file in the class path.