Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import groovy.sql.Sql
- sql = Sql.newInstance("jdbc:jtds:sqlserver://servername\inst1/databaseName",
- "username", "password", "com.microsoft.sqlserver.jdbc.SQLServerDriver")
- sql = Sql.newInstance("jdbc:sqlserver://servername\inst1/databaseName",
- "username", "password", "com.microsoft.sqlserver.jdbc.SQLServerDriver")
- import groovy.sql.Sql
- sql = Sql.newInstance("jdbc:sqlserver://servername\inst1",
- "username", "password", "com.microsoft.sqlserver.jdbc.SQLServerDriver")
- def row = sql.firstRow("select te.tDisplayName from dbName.TableName te where te.Column2=5000006")
- log.info(row.tDisplayName);
- // Registering JDBC Driver
- com.eviware.soapui.support.GroovyUtils.registerJdbcDriver("com.microsoft.sqlserver.jdbc.SQLServerDriver")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement