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
* 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)
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 maxConnectionAg e=0 and db.default. connectionTestS tatement= "SELECT 1"
* Added: db.default.
This seemed to help with the above exception, but now I still occasionally get exceptions. Most recently, "SQLServerExcep tion: The connection is closed." Stack trace attached.
I will try upgrading to the latest snapshot and also setDisableConne ctionTracking( true)