squerylpooling.scala

squerylpooling.scala

 //// SECTION TO SETUP CONNECTION POOLING & DB FOR SQUERYL
  // Setup connection pooling for Squeryl with C3P0
  val cpds = new ComboPooledDataSource
  cpds.setDriverClass("org.h2.Driver")
  cpds.setJdbcUrl("jdbc:h2:mem:test")
  cpds.setUser("sa")
  cpds.setPassword("")

  cpds.setMinPoolSize(5)
  cpds.setAcquireIncrement(1)
  cpds.setMaxPoolSize(10)
  SessionFactory.concreteFactory = Some(() => connection)

  def connection = {
    Session.create(cpds.getConnection, new H2Adapter)
  }