We have Defined the JNDI connection to the external Db through the pega. Whenever pega service started the ext database connection works fine. when they re-start the external db. the Pega looses the connection with external db and display's the following error in log. if we re-start pega service it works fine but if we do not re-start is there a way to auto re-connect to external db.
com.pega.pegarules.pub.database.ConnectionException: There was a problem getting a list: code: 17008 SQLState: 08003 Message: Closed Connection
08:08:42,472 INFO [stdout] (Dispatcher-Thread-93) DatabaseException caused by prior exception: java.sql.SQLRecoverableException: Closed Connection
A SQLRecoverable exception means that the JDBC connection and/or database has encountered a problem during processing, but was able to still complete without loss of data. Its most likely, that the connection in use was simply closed, as external database restarted.
So in datasource please add validate query attribute, this will resolve the issue.