Comment 45 for bug 1243551

Revision history for this message
David Alvarado (davidalv909) wrote :

Another MS Sql Server case of random database exceptions. Original configuration:
 * Play 2.2.0, anorm, Scala with default settings
 * Default version of bonecp that comes with Play 2.2.0
 * MS Sql Server running on Azure VM

I was getting occasional random "SQLException: Timed out waiting for a free available connection." exceptions. Then based on this thread: https://groups.google.com/forum/#!topic/play-framework/7PBnjiXkNuU , I upgraded to:

 * bonecp: 0.8.0.RELEASE
 * Added: db.default.maxConnectionAge=0 and db.default.connectionTestStatement="SELECT 1"

This seemed to help with the above exception, but now I still occasionally get exceptions. Most recently, "SQLServerException: The connection is closed." Stack trace attached.

I will try upgrading to the latest snapshot and also setDisableConnectionTracking(true)