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

Revolutionize Your Business With Generative AI

From product design and software development to virtual agents, content creation, and reporting, GenAI is transforming business. Our AI experts help you unlock GenAI’s full potential and drive growth.

Let’s Get Started

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.