The JDBC data source gets data from the database by using the connection specified in the test step. The data source can either use a project database connection, or a connection specified only for the data source.
The data source assigns values to the properties by matching the names of the database columns or aliases.
Important
In this topic, we focus on how to configure the JDBC data source. We assume you are already familiar with data-driven testing and how to configure a data-driven loop. Otherwise, please read Basic Concepts of Data-Driven Testing, or complete some of our tutorials before you continue.
To use the JDBC data source, you must install a database driver. See Installing Database Drivers for complete information.
You can use data sources of the JDBC type in the Data Source test step in functional tests, and in virtual services.
 |
Stored Procedure
Select this option if your query is a call to a stored procedure. In this case, you specify the name of the stored procedure and its parameters in the SQL Query field.
The passed parameters must be in the same order as they are declared in the database.
ReadyAPI assigns values obtained from database columns to properties with the same names. For example, it assigns the data from the “Order” column to the “Order” property.
 |
Imagine there is the getOrdersByStatus stored procedure in your database. The procedure obtains the data from the Order, ExpDate, and Customer columns for entries that have the specified status. To use the stored procedure:
Create the Order, ExpDate, and Customer properties.
Specify the name of the procedure in the SQL Query field.
Specify the needed parameters in the order declared in the database. In this example, the stored procedure requires two parameters: the first parameter is the desired status, and the second one - a quantity of entries to return.