import groovy.sql.Sql

configurations {
    sqllite
}

repositories {
    mavenCentral()
}

dependencies {
    sqllite 'org.xerial:sqlite-jdbc:3.8.9.1'
}

URLClassLoader loader = GroovyObject.class.classLoader
configurations.sqllite.each { File file ->
    loader.addURL(file.toURL())
}

Sql sql = Sql.newInstance('jdbc:sqlite:test.db', "org.sqlite.JDBC")

task checkSql << {
    sql.execute 'DROP TABLE IF EXISTS TIM'
    sql.execute 'CREATE TABLE TIM(name CHAR(50))'
    sql.execute 'insert into TIM values ("bob")'
    sql.eachRow('SELECT * FROM sqlite_master') { row ->
       // logger.lifecycle row.toString()
       println row
    }
    sql.eachRow('SELECT * FROM TIM') { row ->
        println row
    }
}