Support Article
"No suitable driver found for jdbc:sqlserver" for DB
SA-25202
Summary
When trying to connect to an external database, Test Connection fails with the below error. This issue appears after test succeeds and then a period of inactivity occurs.
Error Messages
Status Value: Problem encountered when getting a database connection: code: 0 SQLState: 08001 Message: No suitable driver found for jdbc:sqlserver://your_server:1433;Database=Test
Steps to Reproduce
Test Connection on a Database rule.
Root Cause
A defect in Pegasystems’ code or rules. Test Connection will not load the jar by itself - if the jar has not been loaded before, it fails with the above error.
This error does not happen when actually connecting to the database in runtime, only when using Test Connection. The issue will be averted if an System Management Application (SMA) lookup is performed as this will reload the class in the JVM.
Resolution
The recommended location for the JDBC jar is in an "endorsed" directory for Tomcat application server.
User is suggested to put the jar under the default "endorsed" location of $CATALINA_HOME/endorsed directory.
While using the JVM argument "-Djava.endorsed.dirs" to "endorse" another location, place the jar in that location.
Published July 11, 2016 - 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.