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
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.
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)
Option | Description | |
---|---|---|
Add | Adds new connection | |
Remove | Removes selected connection | |
Configure | Configures connection properties | |
Test | Tests 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