You can perform direct JDBC calls from Groovy scripts.
This topic describes how to use a Groovy script to register the JDBC driver and connect to the database.
|We recommend using the JDBC Request test step and JDBC data source instead of Groovy scripting.|
Where to use
There are several ways to run this script:
- As a Groovy Script test step.
- As a setup or teardown script on the project, test suite, or test case level in functional tests.
- As a setup or teardown script in security tests.
- As a setup or teardown script in performance tests.
- As a Start, Stop, OnRequest, or AfterRequest script in virtual services.
The following code demonstrates how to register the MySQL JDBC driver and connect to the database:
// Import the Groovy class required to work with SQL databases
// Set up database connection properties
def url = 'jdbc:mysql://mydatabase.com/DatabaseVariable' /* IMPORTANT: must start with jdbc:mysql:// */
def user = 'DatabaseUser'
def password = 'DatabasePassword'
def driver = 'com.mysql.jdbc.Driver'
// Register the MySQL JDBC driver – required for Groovy to send requests to the database
com.eviware.soapui.support.GroovyUtils.registerJdbcDriver( driver )
// Connect to the SQL instance
def sql = Sql.newInstance(url, user, password, driver)
// Use the SQL instance
// Close the SQL instance
|Before registering the driver, you need to place its JAR file to the <ReadyAPI Installation>\bin\ext directory.|