When attempting to connect to DB2 using the C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers\db2jcc4.jar driver, I am receiving the following error message in the log file:
HTTP Error - SERVICE UNAVAILABLE: Could not load JDBC driver class [com.ibm.db2.jcc.DB2Driver]; nested exception is java.sql.SQLException
This connection works with Datamaker, but not in the Portal. I have tried to adding the common.jar and the db24jcclic.jar without success. I have restarted the portal after dropping jar files into the tomcat jdbc-driver folder for each test. I have also tested with these three jar files without success- db2jcc4.jar, db2jcc4_license_cu.jar and db2jcc4_license_cisuz.jar.
If you receive this error, you most likely do not have the jar file in the correct location.
The following forum discussions describe how Tomcat is loading the jar files:
Please copy the db2jcc4.jar file into your tomcat lib directory folder. By default, this is located at C:\Program Files\CA\CA Test Data Manager Portal\tomcat\lib.
If you experience any further issues, please open a support case on https://support.ca.com/irj/portal/newhome or call support at one of these numbers https://www.ca.com/us/services-support/ca-support/contact-support.html.