The DB Client tool enables you to query databases to validate statements. 

In this section:

Connecting the Tool

  1. Click on a test or scenario and choose Add DB Client from the actions drop-down menu. 
  2. In the Connection field, enter the database driver class name, URL, and connection credentials (if required).

    Enable the Close connection option if you want the tool to close the connection to the database after the test executes. This option is recommended when you plan to use the DB tool once. Do not enable this option if multiple DB tools will connect to the same DB. This enables you preserve resources by allowing all of the DB tools to share a connection.

Configuring the Database Query

  1. Specify the query statement in the Query field.
  2. Choose Semicolon or Magic token (typically used for stored procedures) from the Separator drop-down menu. 

    The tool will divide the contents of the SQL query editor by semicolon if the semicolon option is selected. If the magic token option is selected, the Magic token field becomes active so that you can specify a string for dividing the contents of the SQL query editor. A magic token is a string that starts at the beginning of a line and contains only the magic token (with optional white space after the token). 
  3. You can specify an OUT parameter to invoke stored procedures and functions that take OUT parameters or return a value. You can leave this field empty if you are executing a regular SQL query or a stored procedures that does not have any OUT parameters. For each DB tool, the same JDBC OUT parameters are sent to each callable statement. To use different out parameters, create a separate DB tool.

Configuring Runtime Settings

  1. Enable the Fail on SQL Exception option if the tool should fail when a SQL Exception is encountered. If a validation tool is chained as an output to this DB tool, the outcome of that validation will determine this tool’s success or failure, and this setting is not applicable. 
  2. Choose a post query option from the drop-down menu:

Configuring XML Output

The following options are available for outputting the XML response: