Executing Sql script file in Groovy/Gradle

Question

``` def db = [ moduleGroup: 'mysql', moduleName: 'mysql-connector-java', moduleVersion: '5.1.18', driver: "com.mysql.jdbc.Driver", url: 'jdbc:mysql://localhost:3306/bham', user: mySqlUser, password: mySqlPassword ] configurations { sql } task connect << { // This is needed to get mySql driver onto the Groovy/Gradle classpath configurations.sql.each { file -> println "Adding URL: $file" gradle.class.classLoader.addURL(file.toURI().toURL()) } def sql = groovy.sql.Sql.newInstance(db.url, db.user, db.password, db.driver) sql.execute("actStatusCodeLkp.sql") String sqlFilePath = "src/main/resources/sqlscripts/actStatusCodeLkp.sql" String sqlString = new File(sqlFilePath).text sql.execute(sqlString) sql.close() } ``` actStatusCodeLkp.sql ``` insert into act_status_code (id, code, display_name, code_system_name, code_system) values (1, 'active', 'active', 'ActStatus', '2.16.840.1.113883.5.14'); insert into act_status_code (id, code, display_name, code_system_name, code_system) values (2, 'can…

Accepted Answer

Something like this helped me. Notice getting allowMultiQueries: 'true' in the properties

```
def props = [user: grailsApplication.config.dataSource.username, password: grailsApplication.config.dataSource.password, allowMultiQueries: 'true'] as Properties
    def url = grailsApplication.config.dataSource.url
    def driver = grailsApplication.config.dataSource.driverClassName

def sql = Sql.newInstance(url, props, driver)
```

Executing Sql script file in Groovy/Gradle

Solution

Problem