Question
Virtusa Ltd
Virtusa Ltd
IN
Virtusa Ltd
Posted: Nov 15, 2018
Last activity: Nov 15, 2018
Last activity: 15 Nov 2018 10:47 EST
Closed
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:// Proprietary information hidden:5432/postgres DatabaseException caused by prior exception: java.sql.SQLException: No suitable driver found for jdbc:postgresql:// Proprietary information hidden:5432/postgres | SQL Code: 0 | SQL State: 08001 |
| Fail |
Posted: 6 years ago
PEGA
Pegasystems Inc.
US
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.