gilta03

Tech Tip: Unable to connect to DB2 using Portal

Discussion created by gilta03 Champion on May 9, 2017
Latest reply on Aug 14, 2017 by Brian Weissman

This document can also be viewed at https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC1846152.html  

 

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.

 

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.

Outcomes