MySQL/Bonecp Exception when I added a new table

[Pavlos Mitsoulis - Ntompos]

Hi All,

I added a new MySQL Table that references two keys (each from a different table). Then I create a .zip file by running the 'play dist' command. I run the bash script inside the zip file, the evolutions creates the new table (I see it from the SequelPro) but I get the following errors. I've seen many posts saying that the problem is the bonecp. Is that true?

[error] c.j.b.ConnectionHandle - Database access problem. Killing off this connection and all remaining connections in the connection pool. SQL State = HY000
Oops, cannot start the server.
java.sql.SQLException: Connection is closed!
    at com.jolbox.bonecp.ConnectionHandle.checkClosed(ConnectionHandle.java:459)
    at com.jolbox.bonecp.ConnectionHandle.prepareStatement(ConnectionHandle.java:1011)
    at play.api.db.evolutions.Evolutions$.prepare(Evolutions.scala:125)
    at play.api.db.evolutions.Evolutions$.updateLastProblem$1(Evolutions.scala:244)
    at play.api.db.evolutions.Evolutions$.applyScript(Evolutions.scala:271)
    at play.api.db.evolutions.EvolutionsPlugin$$anonfun$onStart$1$$anonfun$apply$1.apply$mcV$sp(Evolutions.scala:472)
    at play.api.db.evolutions.EvolutionsPlugin.withLock(Evolutions.scala:507)
    at play.api.db.evolutions.EvolutionsPlugin$$anonfun$onStart$1.apply(Evolutions.scala:461)
    at play.api.db.evolutions.EvolutionsPlugin$$anonfun$onStart$1.apply(Evolutions.scala:459)
    at scala.collection.immutable.List.foreach(List.scala:318)
    at play.api.db.evolutions.EvolutionsPlugin.onStart(Evolutions.scala:459)
    at play.api.Play$$anonfun$start$1$$anonfun$apply$mcV$sp$1.apply(Play.scala:88)
    at play.api.Play$$anonfun$start$1$$anonfun$apply$mcV$sp$1.apply(Play.scala:88)
    at scala.collection.immutable.List.foreach(List.scala:318)
    at play.api.Play$$anonfun$start$1.apply$mcV$sp(Play.scala:88)
    at play.api.Play$$anonfun$start$1.apply(Play.scala:88)
    at play.api.Play$$anonfun$start$1.apply(Play.scala:88)
    at play.utils.Threads$.withContextClassLoader(Threads.scala:18)
    at play.api.Play$.start(Play.scala:87)
    at play.core.StaticApplication.<init>(ApplicationProvider.scala:52)
    at play.core.server.NettyServer$.createServer(NettyServer.scala:243)
    at play.core.server.NettyServer$$anonfun$main$3.apply(NettyServer.scala:279)
    at play.core.server.NettyServer$$anonfun$main$3.apply(NettyServer.scala:274)
    at scala.Option.map(Option.scala:145)
    at play.core.server.NettyServer$.main(NettyServer.scala:274)
    at play.core.server.NettyServer.main(NettyServer.scala)


Thanks,
Pavlos

[Grégory Bougeard]

what do you use? Slick, ebean, anorm?