How to create and map a database from pega to postgree
i have a requirement of mapping a database to a external postgres db, while i created a datbase rule and tried test connectivity have a error like this:
Status Value:Problem encountered when getting a database connection: code: 0 SQLState: 08001 Message: No suitable driver found for jdbc:postgresql://10.69.167.134:5432/postgres DatabaseException caused by prior exception: java.sql.SQLException: No suitable driver found for jdbc:postgresql://10.69.167.134:5432/postgres | SQL Code: 0 | SQL State: 08001
The jdbc driver needs to be accessible to the application server. For example, for Tomcat you would put it in the TomcatHome\Lib directory. If you've done that, there is a bug in some versions of Pega where test connections will fail even if the jdbc driver is in the correct location, but during runtime it will work fine. This can be corrected by going to SMA (Advanced > ETier Runtime Environment) and looking up the driver class, then retrying the test connection.