External database connectivity - Pega 8.1.3 & MS SQL Server 2017
We are building an application using PRPC version is 8.1.3 running on Pega cloud (Java:1.8)
Requirement: As part of the client requirement, our application needs to integrate with external database MS SQL Server 2017.
Approaches tried: We have tried installing the JDBC jar, created a DSS and restarted the app.
But still getting the same error:
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
We have tried the above approach with the jar files below.
We are currently blocked, any inputs/solutions/suggestions for the above requirement would be appreciated. Has anyone tried the Pega 8.1.3 & MS SQL Server 2017? Please advice.
***Edited by Moderator Marissa to update SR Details***
Hi, We are not hosting the Pega 8.1.3 on MS SQL Server 2017. I guess the support documentation is talking about the compatibility of hosting the Pega 8.x instances. Please correct me if my understanding is wrong and provide any inputs to resolve the issue.
Posted: 2 years ago
Posted: 9 Jul 2019 6:32 EDT
Ankit Rai (raia1)
Senior Engineer, Technical Support - Runtime Engine and Search