Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <p>
- <i>// Import the groovy class required to work with SQL databases.</i><br/>
- <b>import</b> groovy.sql.Sql<br/>
- <br/>
- <i>// Set up database connection properties</i><br/>
- <b>def</b> url = 'jdbc:mysql://mydatabase.com/DatabaseVariable' <i>/* IMPORTANT: must start with jdbc:mysql:// */</i><br/>
- <b>def</b> user = 'DatabaseUser'<br/>
- <b>def</b> password = 'DatabasePassword'<br/>
- <b>def</b> driver = 'com.mysql.jdbc.Driver'<br/>
- <br/>
- <i>// Register MySQL JDBC driver. Required for groovy to send requests to the database.</i><br/>
- com.eviware.soapui.support.GroovyUtils.registerJdbcDriver( driver ) <br/>
- <br/>
- <i>// Connect to sql instance.</i><br/>
- <b>def</b> sql = Sql.newInstance(url, user, password, driver)<br/>
- <br/>
- <i>// Use sql instance.</i><br/>
- <i>// ...</i><br/>
- <br/>
- <i>// Close sql instance.</i><br/>
- sql.close()</p>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement