Question

2
Replies
1274
Views
Vipin Keshri (VipinK17)
Accenture LLP
Lead System Architect
Accenture LLP
IN
VipinK17 Member since 2013 19 posts
Accenture LLP
Posted: August 15, 2017
Last activity: October 4, 2018
Posted: 15 Aug 2017 12:56 EDT
Last activity: 4 Oct 2018 6:46 EDT
Closed

Pega 7 connectivity with MySQL DB

We're trying to connect to mysql, need assistance in establishing connectivity to the database from our PRPC application. We placed the jar file in below location and tested the database connectivity but still getting error as shown further below:
apps/tomcat/8.1.11/lib 

Status Value: Problem encountered when getting a database connection: code: 0 SQLState: 08001 Message: No suitable driver found for jdbc:mysql://radacct-read.sql.frontiernet.net:3306/ECO DatabaseException caused by prior exception: java.sql.SQLException: No suitable driver found for jdbc:mysql://radacct-read.sql.frontiernet.net:3306/ECO | SQL Code: 0 | SQL State: 08001

In pega exchange it is asked to place driver in /usr/share/tomcat7/webapps/prweb/WEB-INF/classes but cannot find this location in our dev server so we placed it in lib folder where rest of DB drivers are stored i.e. apps/tomcat/8.1.11/lib 

PegaExchange link:
https://www.pegaxchange.com/2016/04/23/accessing-external-mysql-database-from-pega-7-prpc/

You inputs are appreciated.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Data Integration Support Case Exists
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.