Unable to connect to DB2 using Portal

Document ID : KB000006618
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.

Environment:
CA Test Data Manager (TDM)- Web Portal
Cause:

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:
http://stackoverflow.com/questions/22984276/db2-driver-not-found-with-tomcat-cp-but-commons-works-fine 
http://stackoverflow.com/questions/2974658/tomcat-db2-jdbc-datasource-configure 

Resolution:

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. 

Additional Information:

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.