Unable to connect to DB2 using Portal

book

Article ID: 6618

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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.

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 

Environment

CA Test Data Manager (TDM)- Web Portal

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.