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??
Thanks for the setting information. I've set the DB2UNIVERSAL_JDBC_DRIVER_PATH and DB2UNIVERSAL_JDBC_DRIVER_NATIVEPATH to "C:\Program Files\IBM\SQLLIB\java" on the WAS, restarted the WAS, but the situation doesn't change.....
I have posted this in another internal link. Reposting it here: have you tried to put the jar under the endorsed directory which by default is: /opt/IBM/WebSphere/AppServer/endorsed_apis:/opt/IBM/WebSphere/AppServer/java_1.7_64/jre/lib/endorsed:/opt/IBM/WebSphere/AppServer/java/jre/lib/endorsed