Test Data Manager

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:
- 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 

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.