Scala Slick c3p0 connection pool using mysql -

Scala Slick c3p0 connection pool using mysql -

i'm total newbie scala , slick in particular. i'm trying utilize c3p0 connection pool mysql backend , slick.

**** persons.scala

scala.slick.driver.mysqldriver.simple._ import scala.slick.lifted.provenshape class persons(tag: tag) extends table[(option[long], string, long)](tag, "persons") { def id: column[long] = column[long]("id", o.primarykey, o.autoinc) def name: column[string] = column[string]("name") def updateddt: column[long] = column[long]("updated_dt") def * : provenshape[(long, string, long)] = (id, name, updateddt) }

**** persondao.scala

import scala.slick.driver.mysqldriver.simple._ object persondao extends app databaseaccess { val persons: tablequery[persons] = tablequery[persons] def insert(id:option[long] = none, name: string, updateddt: long) = databasepool withsession { persons += (id, name, updateddt) } }

**** databaseaccess.scala

import scala.slick.driver.mysqldriver.simple.database import com.mchange.v2.c3p0.combopooleddatasource trait databaseaccess { val url = "jdbc:mysql://192.168.10.12:3306/person" val driver = "com.mysql.jdbc.driver" val database = database.forurl(url, driver = driver) val databasepool = { val ds = new combopooleddatasource ds.setdriverclass(driver) ds.setjdbcurl(url) ds.setminpoolsize(20) ds.setacquireincrement(5) ds.setmaxpoolsize(100) database.fordatasource(ds) } }

error

could not find implicit value parameter session: scala.slick.jdbc.jdbcbackend#sessiondef not plenty arguments method +=: (implicit session: scala.slick.jdbc.jdbcbackend#sessiondef)int. unspecified value parameter session.

scalaversion : 2.11.1

mysqlversion: 5.1.26

c3p0version: 0.9.2.1

link mysql , slick, c3p0 illustration sought.

thanks...

import scala.slick.driver.mysqldriver.simple._ object persondao extends app databaseaccess { val persons: tablequery[persons] = tablequery[persons] def insert(id:option[long] = none, name: string, updateddt: long) = databasepool withsession { implicit session => persons += (id, name, updateddt) } }

try this. missing implicit session parameter.

mysql scala slick c3p0