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

java.sql.SQLException: No suitable driver



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.


Perform the following local-change:
  1. Set the Dynamic System Settings (DSS) value for the driver as below:



  2. 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.
  3. 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

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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