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 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.