sample JDBI with hikariCP

JDBI.scala

package com.neco_labo.db

import com.zaxxer.hikari.{HikariDataSource, HikariConfig}
import org.skife.jdbi.v2.{DefaultMapper, DBI}

import scala.collection.JavaConverters._

object JDBI extends App {

  val config = new HikariConfig()
  config.setJdbcUrl("jdbc:mysql://localhost:3306/db?zeroDateTimeBehavior=round")
  config.setUsername("user")
  config.setPassword("pass")
  config.addDataSourceProperty("dataSourceClassName", "com.mysql.jdbc.jdbc2.optional.MysqlDataSource")
  config.addDataSourceProperty("autoCommit", "false")
  config.addDataSourceProperty("useServerPrepStmts", "true")
  config.addDataSourceProperty("cachePrepStmts", "true")

  val ds = new HikariDataSource(config)

  val dbi = new DBI(ds)

  val h = dbi.open()

  val result = h.createQuery("select * from table")
    .map(new DefaultMapper)
    .iterator().asScala

  result.foreach(println)

  h.close()

  ds.close()

}