Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Database connection close is not happenning

SA-31667

Summary



When user connects to an external DB, the session that is created at DB is not getting closed by Pega.

Only the sessions become inactive sometimes and sometimes the session is active more than three hours.


Error Messages



Not applicable

Steps to Reproduce



Hit the external DB and see the session that is created is not getting closed by Pega and the session or connection still remains the same.

Root Cause



A defect or configuration issue in the operating environment.

The external DB instance which user configured as with JDBC URL as connection type which is leading user to a performance issue as there is no connection pool each time user connects to DB the connection object is never deleted until the session get deleted by DB server.

Resolution



For better performance user must connect to connection pool by using JNDI or 'use with preferences' option to connect to DB.
 

 

Published January 2, 2017 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us