SqlQueryBuilder Download Trial - Free 14 day evaluation

The JDBC Request Window

PDF Print E-mail
User Rating:  / 12
Rate this article: PoorBest 

Overview - JDBC Request Window

jdbc-teststep-pro-references

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
13_snag_evi
Build Query Button
Builds the query by using a wizard
14_snag_evi
Assertions Inspector Panel
List of assertions for the response
15_snag_evi Request Log Inspector Panel
Log of requests
16_snag_evi
XML Result View Displays the query result in plain XML
17_snag_evi
Outline Result View
Displays the query result in outline view

Back to Top

JDBC Request TestStep Toolbar

jdbc-teststep-toolbar

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

Back to Top

Parameters Toolbar

jdbc-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

parameters-table

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

Configuring connection properties

configure-connection

Back to Top

Test the connection

testing-conn-failed

testing-conn-succeeded

Back to Top

Building Complex Queries by Using a Wizard

build-query-main

build-query-sql-preview

build-query-result-preview

and in case of stored procedures

build-query-sp

Back to Top

JDBC Assertions

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

jdbc-request-log

Back to Top

XML Result View

xml-result-view

Back to Top

Outline Result View

outline-result-view

Back to Top