Guest User

Untitled

a guest
Sep 7th, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. soapUI access MS SQL DB from groovy script
  2. import groovy.sql.Sql
  3.  
  4. sql = Sql.newInstance("jdbc:jtds:sqlserver://servername\inst1/databaseName",
  5. "username", "password", "com.microsoft.sqlserver.jdbc.SQLServerDriver")
  6.  
  7. sql = Sql.newInstance("jdbc:sqlserver://servername\inst1/databaseName",
  8. "username", "password", "com.microsoft.sqlserver.jdbc.SQLServerDriver")
  9.  
  10. import groovy.sql.Sql
  11. sql = Sql.newInstance("jdbc:sqlserver://servername\inst1",
  12. "username", "password", "com.microsoft.sqlserver.jdbc.SQLServerDriver")
  13.  
  14. def row = sql.firstRow("select te.tDisplayName from dbName.TableName te where te.Column2=5000006")
  15.  
  16. log.info(row.tDisplayName);
Add Comment
Please, Sign In to add comment