To do the JDBC request from Soap UI, first we need to install the JDBC driver for the database we are using.
I am using SQL Server and so I have downloaded the JDBC driver for SQL server from here.
Extract the *.tar.gz file and copy the sqljdbc4.jar file.
Place this jar file under the “bin\ext\” directory where the SoapUI is installed in your machine.
C:\Program Files (x86)\SmartBear\SoapUI-4.6.4\bin\ext\
Now restart the Soap UI.[CLose and then Open]
Lets test this by creating a JDBC test Request.
1. Right Click on a test case and “Add Step” and clic “JDBC Request”
2. Give the driver name as com.microsoft.sqlserver.jdbc.SQLServerDriver
3. Specify the connection string as
Click on the Test Connection Button.
You should get a prompt like “Connection Tested Successfully”.
Now you are all set to goto make JDBC requests.
Give a sample SQL query under “SQL Query” text area like SELECT * FROM tablename
Run the Request.
You can able to see the results in the xml format.