The JDBC Request Window

NOTE: Some features mentioned on this page are only available in standalone SoapUI Pro that has been replaced with ReadyAPI. To try enhanced JDBC testing functionality, feel free to download a ReadyAPI trial from our website.

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