sqlserver connection through groovy script

Question

I want to make sql connection with windows authentication through sqlserverjdbc jar in SoapUI using groovy. Can anyone help me out, I'm getting an error -

source code -

import sqlserverjdbc.*;
def sql = Sql.newInstance("jdbc:sqlserver://servername/databasename","integratedSecurity=true","com.microsoft.sqlserver.jdbc.SQLServerDriver")

Error - groovy.lang.MissingPropertyException: No such property: Sql for class: Script7 error at line:2

Answer 1

Assuming the driver is on the classpath, you just need to

import groovy.sql.Sql