Use JDBC Drivers From Scripts
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.
Important
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:
Important
Before registering the driver, you need to place its JAR file to the <ReadyAPI Installation>\bin\ext
directory.