JDBC Request Test Step

Values on the Custom JDBC Request Test Step Properties tab are available to other test steps in your project. For instance, you can verify these property values with the Assertion test step, or check them and change the execution flow with the Conditional GoTo test step.

You can modify, add, remove and change custom properties load values of custom properties from a file, or save them to a file. To do this, use the toolbar items. See examples below, for more information.

This tab contains the following properties:

• Properties that correspond to the request parameters.

• A property that provides access to the request and response data.

To connect to a database, you need to specify a connection. You can do it in one of the following ways:

• Select an existing connection from the Connection drop-down list.

• Specify a new connection and share it across all your projects, select the Create New option from the Connection drop-down list.

• Specify a connection specific to the test step by selecting None from the Connection drop-down list and specifying a driver, connection string and password in the fields below. To use the Database Configuration dialog, click Configure.

  This connection will not be available from other test steps, test cases, test suites or projects.

To obtain values from a database, you send an SQL query. In ReadyAPI, you can visually create the desired query:

• Click the Build Query button.

• Use the ensuing Build SQL Query dialog to visually create the desired query. To learn how to do it, see Build SQL Query Wizard.

Alternatively, you can specify the desired query manually by typing it in the SQL Query field.

To specify a call to a stored procedure in a query, do the following:

1. Enable the Stored Procedure option.

2. Enter the name of the stored procedure in the SQL Query field.

3. Specify the needed parameters in the same order as they are declared in a database.

Example

ExampleExample

Click the image to enlarge it.

Imagine there is the getOrdersByStatus stored procedure in your database. To use the stored procedure:

1. Specify the name of the procedure in the SQL Query field.

2. 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 - the quantity of entries to return.

   If a stored procedure uses output parameters, use the question mark (?) to specify them. For example:

   getOrdersByStatus('pending', 5, ?)

To modify test step parameters, use the toolbar buttons that allow you to add, remove parameters, clear its values and change its order. Also, you can import and export a list of parameters from/to a file (see below).

To export parameters to a file, click and specify the file to which you want to save the request parameters.

ReadyAPI exports the list of the request parameters and the ResponseAsXML custom property.

To import parameters from a file:

• Click and specify the file to import in the ensuing Load Properties dialog.

• If the file contains properties that are not specified in the request, ReadyAPI can create them. For this, enable the Create Missing option.

• If the request contains properties that are not specified in the file, ReadyAPI can remove them. For this, enable the Delete Remaining option.

Loading from a file does not affect the ResponseAsXML custom property, even if it is specified in the file.

To use a parameter value in a database query, specify its name after the colon. For example, the following query uses the continent parameter to pass a value to the WHERE clause:

You can use the project, test suite, and other property types as parameter values. To refer to a property, use the following syntax:

• ${#Project#MyPropertyName} – Project properties.

• ${#TestSuite#MyPropertyName} – Test suite properties.

• ${#Env#MyPropertyName} – Environment properties.

For more information, see Property Expansion.

To verify that the server returns the expected response, use assertions:

1. In the Assertions panel in the test step editor and click .

2. In the Add Assertion dialog, specify the desired assertion.

3. Set up a new assertion according to your needs and click OK.

To remove the Content-Length: 0 header from your request, add the -Dsoapui.send.zero.content.length=false parameter to the vmoptions file located in the <ReadyAPI>/bin directory and restart ReadyAPI.