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:
- Add the prconfig/database/drivers/default Dynamic System Settings (DSS) value in com.ibm.db2.jcc.DB2Driver;.
- Navigate to Application > Distribution. Import the JDBC driver (such as db2jcc4.jar) or add the correct -classpath db2jcc4.jar.
- Restart the JVM(s).
Published January 4, 2019 - 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.