DataSourcePool Connection Issues

Avatar

Avatar

mark_mcintyre

Avatar

mark_mcintyre

mark_mcintyre

15-10-2015

Greetings,

We've been experiencing some issues using CQ's DataSourcePool connecting to a MySQL database. Specifically, it will sometimes return an invalid connection (one that throws a CommunicationsException when it's attempted to be used), and over time the pool appears to run out of valid connections entirely (throwing a org.apache.commons.dbcp.SQLNestedException with the message: "Cannot get a connection, pool error Timeout waiting for idle object.").

I notice that the examples provided on http://dev.day.com/docs/en/cq/current/developing/jdbc.html and http://forums.adobe.com/community/digital_marketing_suite/cq5 don't close connections retrieved from the pool. With most pool implementations, connections from the pool should be closed to help inform the pool manager when you're done with an active connection. Is this not how the CQ DataSourcePool works?

Is there anything else I could be missing as well?

Any help would be greatly appreciated.

View Entire Topic

Avatar

Avatar

rohitn62196663

Avatar

rohitn62196663

rohitn62196663

24-01-2017

Thanks for the reply !!!

I reported the issue in a separate link too but didn't get any reply. Below is the link:

http://help-forums.adobe.com/content/adobeforums/en/experience-manager-forum/adobe-experience-manage...
 

I would like to know whether its a known issue with connections pool.