ravichandra
10 years agoOccasional Contributor
Database testing using soap ui/ready api ?
My REST web service populate db records as output.
I can connect to db server using jdbc from soap ui.
How can I compare data populated in REST request and JDBC request ?
Below are few points to consider:
1. The column names in REST request and JDBC request are different but data is same.
2. The order of the records also differs.
So how can I compare data output of REST service and JDBC request ?
Is there any way I modify the output order in both REST service and JDBC request ? so that I can make them to display in same order and compare the data.
Also looking to automate the process for multiple requests.
Please guide me with a right solution
Hope I clearly explained the challenge.
Looking for a right solution.
Thanks,
Ravi