How to add JDBC Step in Soup UI

When we do the automatic testing for web service, we need the JDBC Steps in SoupUI so that we can confirm some value in the Database. How to add the JDBC Steps in SoupUI

a. Adding the file ojdbc14.jar in the folder: C:\Program Files\eviware\soapUI-3.6\lib

Choosing a Global Software Development Partner to Accelerate Your Digital Strategy

To be successful and outpace the competition, you need a software development partner that excels in exactly the type of digital projects you are now faced with accelerating, and in the most cost effective and optimized way possible.

Get the Guide

b. Adding the following string in the Configuration session:

Driver： oracle.jdbc.driver.OracleDriver

Connection String (Sample)：

jdbc:oracle:thin:<User Name>/<Password>@lshrdbd4.dr.avaya.com:1526:esmdev03

c. Click Test Connection to make sure the configuration is correct, and edit your sql statement in the SQL Query Session.