Advertisement
Guest User

Untitled

a guest
Jun 2nd, 2016
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. import groovy.sql.Sql
  2.  
  3. sql = Sql.newInstance("jdbc:jtds:sqlserver://servername\inst1/databaseName",
  4. "username", "password", "com.microsoft.sqlserver.jdbc.SQLServerDriver")
  5.  
  6. sql = Sql.newInstance("jdbc:sqlserver://servername\inst1/databaseName",
  7. "username", "password", "com.microsoft.sqlserver.jdbc.SQLServerDriver")
  8.  
  9. import groovy.sql.Sql
  10. sql = Sql.newInstance("jdbc:sqlserver://servername\inst1",
  11. "username", "password", "com.microsoft.sqlserver.jdbc.SQLServerDriver")
  12.  
  13. def row = sql.firstRow("select te.tDisplayName from dbName.TableName te where te.Column2=5000006")
  14.  
  15. log.info(row.tDisplayName);
  16.  
  17. // Registering JDBC Driver
  18. com.eviware.soapui.support.GroovyUtils.registerJdbcDriver("com.microsoft.sqlserver.jdbc.SQLServerDriver")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement