Question

2
Replies
1206
Views
VipinK17 Member since 2013 14 posts
Accenture Services Pvt Ltd.
Posted: 3 years ago
Last activity: 3 years 1 month ago
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-databas…

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 SR Exists
Moderation Team has archived post
Share this page LinkedIn