Is it possible to execute sql scripts via gradle and get responses if the execution was successful or not?

Old Forum Archive
1

Is it possible to execute sql scripts via gradle and get responses if the execution was successful or not?

2

Possibly easiest to use Groovy Sql directly http://groovy.codehaus.org/api/groovy/sql/Sql.html

3

Thanks for the hint =)

I tried this:

def db = [
  url: 'jdbc:sqlserver://TestUrl',
  user: 'TestUser',
  password: 'TestPW',
  driver: 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
 ]
   def sql = Sql.newInstance(db.url, db.user, db.password, db.driver)

Unfortunately i get an error if i want to create a new instance. (Could not create an instance of type ext_Decorated) I use a ms sql server

Do I miss something important?

Regards

4

What’s the exception? Try running with “-S” on the command line to get a full stack trace.

You possibly need to

import groovy.sql.*

Or perhaps you need to add the sql server jdbc jar to the

buildscript {
   dependencies { ... }
}
5

Hmmm… it seems there’s classpath issues declaring the jdbc jar in the buildscript dependences.

See this thread for a solution http://stackoverflow.com/questions/6329872/how-to-add-external-jar-files-to-gradle-build-script

6

This was actually very helpfull and solved my problem. Thank you =)

The Code:

import groovy.sql.Sql
  defaultTasks 'connectToDb'
  repositories {
    flatDir name: 'localRepository', dirs: 'lib'
}
configurations {
    driver
}
dependencies {
 driver group: 'sql', name: 'sqljdbc4'
}
  URLClassLoader loader = GroovyObject.class.classLoader
configurations.driver.each {File file ->
    loader.addURL(file.toURL())
}
  task connectToDb << {
    def props = [user: 'sa', password: 'pw', allowMultiQueries: 'true'] as Properties
    def url = 'jdbc:sqlserver://testserver;databaseName=testDB'
    def driver = 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
    def sql = Sql.newInstance(url, props, driver)
   //do stuff
    sql.close()
}