Question

22
Replies
1928
Views
ToshihideSato Member since 2016 2 posts
Posted: September 7, 2015
Last activity: September 28, 2015
Closed
Solved

Loading DB2 JDBC (db2jcc.jar) driver on startup of WebSphere Application Server

I am currently using Pega 7.1.9 on WebSphere Application Server v 8.5.5 and DB2 10.5 LUW which is installed in a PC server (192.168.100.1).

I created a database rule which uses JDBC definition and it's URL points to external DB2 database (192.168.100.12).

Whenever I click on "Test connection" button, I get an error "Status Value: Problem encountered when getting a database connection: code: 0 SQLState: 08001 Message: No suitable driver Fail", which seems to be the JDBC driver is not loaded.

To get this to work, I need to go to

System Management Application -> select node -> Advanced -> ETier Runtime Environment, and for a "Java Class Name:" text box, type "com.ibm.db2.jcc.DB2Driver" and click "Lookup Java Class" to search for the JDBC driver for DB2.

After doing this step and go back to "Test Connection", I will be able to connect to the database.

I do not want to go to SMA and lookup for the driver to load the JDBC driver. Is there a correct way to load the JDBC driver at the startup of WebSphere Application Server??

Low-Code App Development Installation and Deployment System Administration
Moderation Team has archived post
Share this page LinkedIn