Jdbc driver class cannot be loaded with gradle 2.0 (but worked with 1.12)

Old Forum Archive
3

Thanks for your reply. Here is the sample:

import groovy.sql.Sql
apply plugin: 'groovy'
   repositories {
 mavenCentral()
}
  configurations {
 jdbcdriver
}
  dependencies {
 jdbcdriver 'com.h2database:h2:1.3.173','org.postgresql:postgresql:9.3-1100-jdbc41'
 }
  task loadDB << {
 //we need this hack to satisfy the classloader conditions for javax.sql.DriverManager
 URLClassLoader loader = GroovyObject.class.classLoader
 configurations.jdbcdriver.each {File file ->
  loader.addURL(file.toURI().toURL())
 }
 //Class.forName() is part of the above hack
 println "jdbc drivers: "+Class.forName("org.h2.Driver")+", "+Class.forName("org.postgresql.Driver")
 println "connecting to database"
 def sql= Sql.newInstance("jdbc:h2:mem:test", "sa", "sa")
 sql.execute("create table users (id int primary key, name varchar(40), email varchar(40))")
 sql.execute("insert into users (id, name,email) values (1,'mick', 'mick@test.com')")
 sql.close()
}