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.

Example

The following code demonstrates how to register the MySQL JDBC driver and connect to the database:

Groovy

// Import the Groovy class required to work with SQL databases
import groovy.sql.Sql

// 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
sql.close()

Before registering the driver, you need to place its JAR file to the <ReadyAPI Installation>\bin\ext directory.

Use JDBC Drivers From Scripts

Where to use

Example

See Also