Question
SSA
US
Last activity: 20 Dec 2017 16:41 EST
Regarding the External DB Connection
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
08:08:42,472 INFO [stdout] (Dispatcher-Thread-93) | SQL Code: 17008 | SQL State: 08003
Pegasystems Inc.
IN
Hi,
I am not really sure but is your IP changing when you restarting?
Are you able to connect to DB after restart without any modification?
Only thing that can go wrong here is JNDI settings so see if the restart is affecting it in any way
Thank You.
Pegasystems Inc.
IN
Hi Ravinder,
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.
SSA
US
Yes the validate query attribute is there but that's not working? SqlServer DB