MySQLNonTransientConnectionException with BoneCP 0.8.0-rc1

What's your config? Can I have a sample test? Can you try it with 0.8.0-rc3-SNAPSHOT?

Hello,

I'm using BoneCP (0.8.0.RELEASE) as part of Play! 2.2.1, and I am having similar problems. My configuration is as follows:

db.default.driver=com.mysql.jdbc.Driver
db.default.url="jdbc:mysql://my-host/database-name"
db.default.user=user
db.default.password=password

The problem comes up after a period of idleness, and is intermittent. As you can see from the stacktrace below, the error occurs right after getting a connection. There is an attempt to set auto_commit, but it appears the connection the pool gave us was closed.

Thank you for your prompt attention to this issue.

@6g5hhg1nb: Execution exception in null:null
 at play.api.Application$class.handleError(Application.scala:293)
 at play.api.DefaultApplication.handleError(Application.scala:399)
 at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$12$$anonfun$apply$1.applyOrElse(PlayDefaultUpstreamHandler.scala:165)
 at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$12$$anonfun$apply$1.applyOrElse(PlayDefaultUpstreamHandler.scala:162)
 at scala.runtime.AbstractPartialFunction.apply(AbstractPartialFunction.scala:33)
 at scala.util.Failure$$anonfun$recover$1.apply(Try.scala:185)
 at scala.util.Try$.apply(Try.scala:161)
 at scala.util.Failure.recover(Try.scala:185)
 at scala.concurrent.Future$$anonfun$recover$1.apply(Future.scala:387)
 at scala.concurrent.Future$$anonfun$recover$1.apply(Future.scala:387)
 at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:29)
 at play.api.libs.iteratee.Execution$$anon$1.execute(Execution.scala:43)
 at scala.concurrent.impl.CallbackRunnable.executeWithValue(Promise.scala:37)
 at scala.concurrent.impl.Promise$DefaultPromise.tryComplete(Promise.scala:133)
 at scala.concurrent.Promise$class.complete(Promise.scala:55)
 at scala.concurrent.impl.Promise$DefaultPromise.complete(Promise.scala:58)
 at scala.concurrent.Future$$anonfun$flatMap$1$$anonfun$apply$3.apply(Future.scala:278)
 at scala.concurrent.Future$$anonfun$flatMap$1$$anonfun$apply$3.apply(Future.scala:278)
 at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:29)
 at scala.concurrent.Future$InternalCallbackExecutor$Batch$$anonfun$run$1.processBatch$1(Future.scala:731)
 at scala.concurrent.Future$InternalCallbackExecutor$Batch$$anonfun$run$1.apply$mcV$sp(Future.scala:746)
 at scala.concurrent.Future$InternalCallbackExecutor$Batch$$anonfun$run$1.apply(Future.scala:723)
 at scala.concurrent.Future$InternalCallbackExecutor$Batch$$anonfun$run$1.apply(Future.scala:723)
 at scala.concurrent.BlockContext$.withBlockContext(BlockContext.scala:72)
 at scala.concurrent.Future$InternalCallbackExecutor$Batch.run(Future.scala:722)
 at scala.concurrent.Future$InternalCallbackExecutor$.scala$concurrent$Future$InternalCallbackExecutor$$unbatchedExecute(Future.scala:782)
 at scala.concurrent.Future$InternalCallbackExecutor$.execute(Future.scala:773)
 at scala.concurrent.impl.CallbackRunnable.executeWithValue(Promise.scala:37)
 at scala.concurrent.impl.Promise$DefaultPromise.tryComplete(Promise.scala:133)
 at scala.concurrent.Promise$class.complete(Promise.scala:55)
 at scala.concurrent.impl.Promise$DefaultPromise.complete(Promise.scala:58)
 at scala.concurrent.Future$$anonf...