Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Suitable driver not found to connect to external DB2 database

SA-68475

Summary



Error occurs when connecting to DB2 from Designer Studio.

However, able to connect to DB2 from WebSphere and Oracle SQL Developer.



Error Messages



Test Database ConnectionStatus
DatabaseException caused by prior exception: java.sql.SQLException: No suitable driver found



Steps to Reproduce



Connect to DB2 from Designer Studio.


Root Cause



Not Applicable


Resolution



Perform the following local-change for any external database type:
  1. Add the prconfig/database/drivers/default Dynamic System Settings (DSS) value in com.ibm.db2.jcc.DB2Driver;.
  2. Navigate to Application > Distribution. Import the JDBC driver (such as db2jcc4.jar) or add the correct -classpath db2jcc4.jar.
  3. Restart the JVM(s).
Suggest Edit

Published January 4, 2019 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us