Overview - JDBC Request Window

| Option | Description | |
|---|---|---|
| JDBC Request TestStep Toolbar |
Overall control of the JDBC Request TestStep |
|
| Parameters Toolbar |
Control over JDBC Request TestStep parameters |
|
| Parameters Table |
Table of parameters to be replaced when running the query |
|
| Configured JDBC Connection |
JDBC Connection to select from a list of connections defined on a project level |
|
| Configure Button for the Connection |
Starts the wizard for re-configuring current selected connection |
|
| Driver | Used in case connection is set to NONE. You can find links to the most common drivers here. |
|
| Connection string |
Used in case connection is set to NONE |
|
| Password | Used in case connection is set to NONE |
|
| Configure Button for Plain Connecting Properties |
Starts the wizard for configuring plain connection properties |
|
| Test Connection Button |
Tests if the connection to database can be established for given option |
|
| SQL Query Area |
SQL Query to be executed |
|
| Stored Procedure Check Box |
Indicates if given query is a call of stored procedure |
|
| Build Query Button |
Builds the query by using a wizard |
|
| Assertions Inspector Panel |
List of assertions for the response |
|
| Request Log Inspector Panel |
Log of requests | |
| XML Result View | Displays the query result in plain XML | |
| Outline Result View |
Displays the query result in outline view |
JDBC Request TestStep Toolbar
![]()
| Option | Description | |
|---|---|---|
| Run | Submit JDBC Request |
|
| Abort | Abort ongoing JDBC request |
|
| Add assertion |
Add an assertion to JDBC Request |
Parameters Toolbar
![]()
| Option | Description | |
|---|---|---|
| Add | Adds a property to the property list | |
| Remove | Removes the selected property from the property list | |
| Move Up | Moves selected property up one row | |
| Move Down | Moves selected property down one row | |
| Clear | Clears all current property values | |
| Load | Loads property values from an external file | |
| Save | Saves current property values to a file |
Parameters Table
| Option | Description |
|---|---|
| Name | Unique parameter identifier |
| Value | Parameter value to be replaced in the SQL query |
Configuring connection properties
Test the connection


Building Complex Queries by Using a Wizard
and in case of stored procedures

JDBC Assertions

| Option | Description |
|---|---|
| JDBC Timeout |
Asserts if JDBC request got response in the amount of time specified as a JDBC TestStep property |
| JDBC Status |
Asserts if the query was successfully executed |
Request Log
XML Result View

Outline Result View










