Support Article
Unable to Connect to an external DB2 database
SA-65554
Summary
Unable to connect to an external DB2 database.
Error Messages
Problem encountered when getting a database connection: code: 0 SQLState: 08001 Message: No suitable driver found for jdbc:db2://1X.X.XX:X0000/cm DatabaseException caused by prior exception: java.sql.SQLException: No suitable driver found for jdbc:db2://1X.XX.XX:X0000/cm | SQL Code: 0 | SQL State: 08001
Fail
Steps to Reproduce
Create a database rule in the application as external database with DB2.
Root Cause
An issue in the custom application code or rules.
Issue with loading the DB2 driver.
Resolution
Perform the following local-change:
- Import the DB2 driver RAR files from the Developer portal to the Customer CodeSet.
- Add the below prconfig.xml.
<env name="database/drivers" value="com.ibm.db2.jcc.DB2Driver"/>
- Restart the server.
Published October 12, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.