The JDBC Request Window

User rating:
2.4 (14 ratings)

Overview - JDBC Request Window


Option Description
1_snag_evi JDBC Request TestStep Toolbar
Overall control of the JDBC Request TestStep
2_snag_evi Parameters Toolbar
Control over JDBC Request TestStep parameters
3_snag_evi Parameters Table
Table of parameters to be replaced when running the query
4_snag_evi Configured JDBC Connection
JDBC Connection to select from a list of connections defined on a project level
5_snag_evi Configure Button for the Connection
Starts the wizard for re-configuring current selected connection
6_snag_evi Driver Used in case connection is set to NONE. You can find links to the most common drivers here.
7_snag_evi Connection string
Used in case connection is set to NONE
8_snag_evi Password Used in case connection is set to NONE
9_snag_evi Configure Button for Plain Connecting Properties
Starts the wizard for configuring plain connection properties
10_snag_evi Test Connection Button
Tests if the connection to database can be established for given option
11_snag_evi SQL Query Area
SQL Query to be executed
12_snag_evi 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
15_snag_evi 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

Back to Top

JDBC Request TestStep Toolbar


Option Description
run Run Submit JDBC Request
Abort Abort ongoing JDBC request
addAssertion Add assertion
Add an assertion to JDBC Request

Back to Top

Parameters Toolbar


Option Description
add_property Add Adds a property to the property list
remove_property Remove Removes the selected property from the property list
up_arrow Move Up Moves selected property up one row
down_arrow Move Down Moves selected property down one row
clear_properties Clear Clears all current property values
load_properties Load Loads property values from an external file
set_properties_target Save Saves current property values to a file

Back to Top

Parameters Table


Option Description
Name Unique parameter identifier
Value Parameter value to be replaced in the SQL query

Configuring connection properties


Back to Top

Test the connection



Back to Top

Building Complex Queries by Using a Wizard




and in case of stored procedures


Back to Top

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

Back to Top

Request Log


Back to Top

XML Result View


Back to Top

Outline Result View


Back to Top