01 March 2010 - 3.5 user guide eclipse intellij netbeans maven download nightly forum bugs blog sf.net eviware


Eviware Logo

JDBC Request Steps

JDBC Request Steps are standalone JDBC requests that can be used to submit SQL query and get the result in XML format. They are added via the TestCase Editors popup menu with the "Add Step -> JDBC Request" option.

JDBC Test Request Details Tab

The "Details" tab shown in the bottom-left shows standard Name and Description of particular TestStep, and introduces two more properties

  • Max Rows
  • Query Timeout
  • The JDBC Test Request Editor

    Double-clicking a JDBC Test Request in either the navigator or the TestCase Editor Pane opens the requests editor which is split into two parts

    • The first part is standard properties table layout which contains properties to be replaced in SQL query through PreparedStatement

    • The second part contains connection details, SQL query and information if it's a stored procedure or not.

    In SoapUI Pro there is additional option of using Database connection set on project level(see Project JDBC Connections) and generating SQL query using a wizard (see SQL Query wizards)

    The JDBC Test Request Response View

    Response view has standard XML and Outline tabs, and it's content can be asserted in a standard way( see Test Request Assertions for more detailed information about assertions)

    For more detailed description on how to use this TestStep please have a look at JDBC Request TestStep tutorial


    Next: AMF Requests