Suitable driver not found to connect to external DB2 database
Error occurs when connecting to DB2 from Designer Studio.
However, able to connect to DB2 from WebSphere and Oracle SQL Developer.
Test Database ConnectionStatus
DatabaseException caused by prior exception: java.sql.SQLException: No suitable driver found
Steps to Reproduce
Connect to DB2 from Designer Studio.
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).