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
In some version(s) there was an issue where you would have to lookup the class in SMA (Advanced > ETier runtime environment) before it would work via a test connection (though it would work during actual processing).