Service Virtualization

Hello,

My requirement is to filter all rows returned from JDBC resultset and validate all the column values present in each row against the values present in a xml. Also the main condition is that row count is not fixed , so I cannot use "extract value from jdbc resultset" filter , since it accept row count as integer only , I cannot use any property.

Any help would be appreciated.

Can you try to write the Step response from the JDBC step to  a  file  and compare that file with the XML ?  

Hi,

    Create a Dataset using "Read rows from JDBC Table" which will create a datasheet based on the query you gave in the dataset and it creates properties for all the columns. Then in next step, read the xml file and apply "XML Xpath filter" and apply xpath query to the xml content and save each attribute to the property.

    Now, you have both the properties. One from database and one from Xml. So, you can compare it using any assertions or you can write "scripted assertion" to compare these properties.

Thanks & Regards

Srikanth Gajawada