Soap UI – Make JDBC Requests

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.

http://www.microsoft.com/en-in/download/details.aspx?id=11774

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

jdbc:sqlserver://<servername>:1433;databaseName=<databasename>;user=<username>;password=<password>;

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s