Support Article
java.sql.SQLException: No suitable driver
SA-73625
Summary
JDBC driver is configured to connect to an external SQL Server database. Error occurs on clicking the Test Connection.
Error Messages
Status Value: In order to connect to a specific external database, the Pega server must be restarted after the jdbc driver jar has been added to the classpath and the jdbc driver class name has been defined in prconfig.xml. e.g. database/drivers="oracle.jdbc.OracleDriver;com.sybase.jdbc4.jdbc.sybdriver" : code: 0 SQLState: 08001 Message: No suitable driver DatabaseException caused by prior exception: java.sql.SQLException: No suitable driver | SQL Code: 0 | SQL State: 08001
Steps to Reproduce
Configure the JDBC driver to connect to an external SQL Server database.
Root Cause
A software use or operation error.
Resolution
Perform the following local-change:
- Set the Dynamic System Settings (DSS) value for the driver as below:
Pega-Engine • prconfig/database/drivers/default
Value: com.microsoft.sqlserver.jdbc.SQLServerDriver;org.postgresql.Driver
- The driver Jar was imported in to a custom unknown ruleset which was not defined in Pega. Reimport the driver Jar to the Custom codeset.
- Use the below query to delete the earlier record from the database.
delete from pr_engineclasses where pzjar like '%mssql-jdbc-7.0.0.jre8.jar%' and pzcodeset = '<custom codeset name>'
Published March 28, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.