Support Article
Not returning connection 0 for database "pegadata" to the pool
SA-36873
Summary
Frequent Connection pool exceptions in the logs with Pega 7.2.
Error Messages
Not returning connection 0 for database "pegadata" to the pool
Steps to Reproduce
Not Applicable
Root Cause
Number of available connections are insufficient.
Resolution
Make the following change to the operating environment:
1. Insert the following attributes into the Resource element for the jdbc/PegaRULES connection
Not returning connection 0 for database "pegadata" to the pool as it previously encountered the following error:
testOnBorrow="true"
testOnConnect="true"
testOnReturn="true"
testWhileIdle="true"
validationQuery="select 1"
2. Add below entries in PRConfig.xml:
<env name="classmap/usemergestatement" value ="false" />
<env name="database/batchupdates" value="-1" />
Published December 18, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.