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

23-01-2017

Hello all,

I have a similar problem with day commons connections pool. After some time the connections to the data base are getting timed out. Is it an issue with the connections pool iotself. Any solution for this. Below is the error I got.

SQL exception while storing data in table java.sql.SQLRecoverableException: IO Error: Connection timed out

I even added the validation query i.e. "select 1 from dual" but still its throwing the connection time out errors.