How to Setup JDBC connections with SOAP UI - Bug Reaper

                  Bug Reaper

Lean about Automation Testing,Selenium WebDriver,RestAssured,Appium,Jenkins,JAVA,API Automation,TestNG,Maven, Rest API, SOAP API,Linux,Maven,Security Testing,Interview Questions

Friday, 5 September 2014

How to Setup JDBC connections with SOAP UI

Hi Reader,

SoapUI provides the provision of JDBC connectivity.

We can easily connect Our Database with SoapUI, following mentioned below steps:


1.Download JDBC Driver jar file (Click here)
2.Copy it in your ext folder present under bin folder of SoapUI, example(C:\Users\Neeraj Bakhtani\Desktop\soapui-4.5.1\bin\ext)
3.Put JAVA_Home path i.e. C:\Program Files\Java\jdk1.7.0_10 (under Soap Ui> File>Preference>Tools> JDK 1.5 javac)



you will find this path in Enviorment Variable

4.Now in Soap UI TestSuite , Make a JDBC Request.



5.In Driver mention > oracle.jdbc.driver.OracleDriver.(Refer Below screenshot)
6.In Connection String> jdbc:oracle:thin:username/passwrd@Host_ip:port:SID.(Refer Below Screen)




 JDBC Connection Toolbar

jdbc-connections-toolbar

OptionDescription
add_propertyAddAdds new connection
remove_propertyRemoveRemoves selected connection
configure-dbconnectionConfigureConfigures connection properties
runTestTests the database connection


7.Restart Soap UI.
8.Test connection
9.Write the Query in SQL Query and execute it from the Top Button (>).
10. You will get the response of your query in Right Section of SoapUI.

No comments:

Post a Comment