DB2 JDBC error

[Former Member]

Hi,

Can anybody suggest me a way to solve the following error. I am getting this error activating the JDBC channel.

Driver type: Type 4 DB2 universal JDBC driver

Provider.xml file:

<jars>

<jar-name>db2jcc.jar</jar-name>

<jar-name>db2jcc_license_cu.jar</jar-name>

</jars>

Processing Error: Accessing database connection 'jdbc:db2://cldrdgw1.is.xxxxx.com:2998/CTC_JDTA' failed: com.ibm.db2.jcc.b.SqlException: The version of the IBM Universal JDBC driver in use is not licensed for connectivity to QDB2 databases. To connect to this DB2 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 classpath. Connectivity to QDB2 databases is enabled by any of the following license files: { db2jcc_license_cisuz.jar }

Addtional information: JDBC driver 'com.ibm.db2.jcc.DB2Driver' loaded successfully, additional driver information:

Available JDBC drivers:

com.ibm.db2.jcc.DB2Driver, 2.6 JDBC compliant

Thanks for the help

[Former Member · Accepted solution]

Sudhir is right. You need to include db2jcc_license_cisuz.jar in your driver installation.

On details of DB2 JDBC driver, refer to:

http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/ad/t0010264.ht...

Include all the required jar files in provider.xml. Make the sda again including all these jars, and re-install the JDBC driver.

regards,

Pops

[Former Member]

Thanks for all your valuable input, Installed type 2 driver and its working now.

[former_member187339]

Hi Daya,

Might be some problems with your drivers, Have a look at the following thread:

Regards

Suraj