Question

5
Replies
1061
Views
VKDURBHA Member since 2012 5 posts
Virtusa
Posted: 1 year ago
Last activity: 1 year 2 months ago
Closed

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.

mssql-jdbc-7.2.2.jre8.jar

sqljdbc42.jar

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***

Data Integration Cloud Services SR Exists
Moderation Team has archived post
Share this page LinkedIn