sepatel / inigma-shared

This project is no longer maintained. Common Libraries used for Web Applications
Apache License 2.0
3 stars 0 forks source link

DynamicDatasource Damaged Connections #2

Closed sepatel closed 12 years ago

sepatel commented 12 years ago

It does not appear that bonecp is actually executing the sql statement on checkout to ensure that the connection is valid before handing it out. There seems to be a discrepency between how it worked under c3p0 and bonecp but a damaged sql statement never seems to recover.

sepatel commented 12 years ago

Not true, it does not auto-reconnect and get you a valid connection on the getConnection call however, on a SQLException which represents a connectivity issue, it does close the existing connection out of the pool and attempts to acquire a new connection.