JDBC Request is a test step available in soapUI where the user can query the database and get the records in an XML format. JDBC Request can use an already configured JDBC Connection or it can configure after adding the step.
The below image shows a JDBC Request using an already configured JDBC Connection.
It also uses a parameter named "id" with a value "12345" which is used in the query. This is the way one can use parameters in the query. The parameters are represented with a ":" before the parameter name in the SQL. Once the step is executed, the results will be shown in the results window in a XML format. These results can be accessed as XML elements in any other test step or in soapUI assertions.
Posts
How do you change the JDBC Timeout assertion value? Seems to default to 60 ms.
Figured it out, set the queryTimeout value on the TestStep... you can only edit the XML manually, as it cannot be done via the UI.
Great!! Thanks for sharing that David..