Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- soapUI access MS SQL DB from groovy script
- 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);
Add Comment
Please, Sign In to add comment