I searched the forums for a solution to this problem, but could not find anything relevant.

I'm trying to configure ReportCaster to use a Type 4 JDBC driver to connect to DB2. Initially when I installed I didn't configure it properly. I've modified the install.cfg as follows:

JDBC Classpath = /opt/db2/db2jcc.jar:/opt/db2/db2jcc_license_cu.jar
Repository URL = jdbc:db2://hostname:50010/dbname;driverType=4;
Repository Class = com.ibm.db2.jcc.DB2Driver

Despite these changes, ReportCaster is blowing up trying to load the type 2 driver. scheduler.log shows the following errors:

com.ibm.db2.jcc.am.SqlException: [jcc][10389][12245][3.62.56] Failure in loading native library db2jcct2, java.lang.UnsatisfiedLinkError: no db2jcct2 in java.library.path: ERRORCODE=-4472, SQLSTATE=null
at com.ibm.db2.jcc.am.fd.a(fd.java:660)
at com.ibm.db2.jcc.am.fd.a(fd.java:60)
at com.ibm.db2.jcc.am.fd.a(fd.java:94)
at com.ibm.db2.jcc.t2.a.a(a.java:37)
at com.ibm.db2.jcc.t2.T2Configuration.(T2Configuration.java:95)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:424)

The t2 package, T2Configuration class, and the fact that it's attempting to load a native library lead me to believe that it's still trying to use a type 2 driver.

Any help would be appreciated.

Thanks,
Dave

This message has been edited. Last edited by: Dave02,

Update:

I've gotten it working. I did not realize that the install.cfg was not an actual config file and that I needed to use the bin/repurl and bin/repclass scripts to actually update the installation.

Thanks,
Dave