/*
* First create the table
*
* mysql -u username --password=password -D test \
* -e "create table Tab(col VARCHAR(100));"
*
*/
import scala.dbc._
import scala.dbc.Syntax._
import syntax.Statement._
import java.net.URI
import scala.compat.Platform


object Test extends Application{
    val db = new Database(
      new Vendor {
        val nativeDriverClass = java.lang.Class.forName("com.mysql.jdbc.Driver")
        val uri = new URI("jdbc:mysql://localhost/test")
        val user = "username"
        val pass = "password"
        val urlProtocolString = "jdbc:mysql"
        val retainedConnections = 1
    
      })

    val res = db.executeStatement({
      select fields ("col" of characterVarying(100)) from "Tab"
    }, true)

    System.out.println(res.elements.hasNext)
}