JDBC test assertions
As we used various assertions with SOAP request TestStep, JDBC Request can also make use of most of those assertions. In soapUI, most of the assertions are independent from the TestSteps. Hence, the assertions such as contains and Xpath match can be used with JDBC Request TestStep as they are. By clicking on the Adds an assertion to this item icon at the top menu of JDBC Request TestStep, you can find out what assertions are supported by the TestStep. In addition to the generic assertions, you will find two JDBC Request TestStep-specific assertions there:
JDBC Timeout: This assertion can be used to verify whether the current SQL query is executed within the specified Query Timeout property value
JDBC Status: In order to check whether the SQL statement is executed successfully, we can use the JDBC Status assertion
Let's add a JDBC assertion to our sample selectGuests JDBC Request in GuestManagementServiceTestSuite:
Select selectGuests JDBC Request and click on add assertion...
