Unable to Connect to an external DB2 database
Unable to connect to an external DB2 database.
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
Steps to Reproduce
Create a database rule in the application as external database with DB2.
An issue in the custom application code or rules.
Issue with loading the DB2 driver.
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.