ClobMeta.scala

 case class BigString(value: String) extends AnyVal 
 
 def getClob(rs: ResultSet, i: Int): BigString = {
    val clob = rs.getClob(i)
    val str = Source.fromInputStream(clob.getAsciiStream).mkString
    BigString(str)
  }
  def setClob(ps: PreparedStatement, i: Int, bs: BigString): Unit = {
    val reader = new StringReader(bs.value)
    ps.setClob(i, reader)
  }
  def updateClob(rs: ResultSet, i: Int, bs: BigString): Unit = {
    val reader = new StringReader(bs.value)
    rs.updateClob(i, reader)
  }
  implicit val ClobMeta: Meta[BigString] = Meta.advanced(NonEmptyList.of(JdbcType.Clob), NonEmptyList.of("CLOB"), getClob, setClob, updateClob)