SoapUI: JDBC Step example

Follow these steps to prepare your first jdbc step in SoapUI

1) Copy & paste the oracle driver jar file in SoapUi’s lib directory
2) Create a jdbc step

example configuration of the newly created jdbc step as follows :

a) Driver: oracle.jdbc.driver.OracleDriver
b) Connection String:

Write your query string “select * from departments”

Add assertion with “contains”

Run your step and observe!

SoapUI: Using Variables

You can use variables to your request so that you don’t have to change your request body every time.

Your project > Custom properties

Add your project variables

You can add variables by these steps:

1) keep your cursor on your request location (where you want to put your project variables)

2) Right click , use “Get Data..” , choose your variables from project section.

SoapUI: Groovy Script for accessing Mock Service Request

If you want to access your mock service request pragmatically via Groovy Script step and perform assertion, then you can following this sample code.

def mockService =testRunner.testCase.testSuite.project.getMockServiceByName("SampleMockService")

def mockOperation=mockService.getMockOperationByName("SampleRequest");

def requestContent=mockOperation.getLastMockResult().getMockRequest().getRequestContent(); "result was: " +requestContent;

def found=null

if(requestContent.contains( "Your Key Word" ))
{"content found!")



File file = new File("C:/temp/ExampleResult.txt")
file.write requestContent
println file.text

assert found=="found"