How to Match values in JSON response with JDBC response? just want to check that correct values passing in JSON response and need to verify that those values are matched with JDBC response (fetching data from Database). It is better to Explain with example.
Not knowing the details of JDBC and JSON response it is hard to provide exact configuration, from the high level perspective it should be something like:
- Add JSON Extractor and store "interesting" part(s) of the response into JMeter Variable(s)
- Add JDBC PostProcessor and store values from the DB into JMeter Variable(s). See Debugging JDBC Sampler Results in JMeter guide to learn how to do it
Add Response Assertion (one assertion per variable) to test if variables are equal. Make sure that assertions are placed after the JSON Extractor and JDBC PostProcessor: