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.