Instead of using checkConnectionsOnCheckout (too expensive), I'd like to only use the idleConnectionTestPeriod. But if a connection fails the test, I'd like c3p0 to flag every other idle connection in the pool as "suspicious". "Suspicious" connections get tested on-checkout. A "suspicious" connection is unflagged when it passes a test, either due to on-checkout testing or idle connection testing.
This approach would keep things speedy but also avoid bad connections in the pool.
Log in to post a comment.