Advertisement
Guest User

Untitled

a guest
Feb 16th, 2017
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. <p>
  2. <i>// Import the groovy class required to work with SQL databases.</i><br/>
  3. <b>import</b> groovy.sql.Sql<br/>
  4. <br/>
  5. <i>// Set up database connection properties</i><br/>
  6. <b>def</b> url = 'jdbc:mysql://mydatabase.com/DatabaseVariable' <i>/* IMPORTANT: must start with jdbc:mysql:// */</i><br/>
  7. <b>def</b> user = 'DatabaseUser'<br/>
  8. <b>def</b> password = 'DatabasePassword'<br/>
  9. <b>def</b> driver = 'com.mysql.jdbc.Driver'<br/>
  10. <br/>
  11. <i>// Register MySQL JDBC driver. Required for groovy to send requests to the database.</i><br/>
  12. com.eviware.soapui.support.GroovyUtils.registerJdbcDriver( driver ) <br/>
  13. <br/>
  14. <i>// Connect to sql instance.</i><br/>
  15. <b>def</b> sql = Sql.newInstance(url, user, password, driver)<br/>
  16. <br/>
  17. <i>// Use sql instance.</i><br/>
  18. <i>// ...</i><br/>
  19. <br/>
  20. <i>// Close sql instance.</i><br/>
  21. sql.close()</p>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement