Forum Discussion

ravichandra's avatar
ravichandra
Occasional Contributor
10 years ago

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