Question
How to Compare 2 JDBC response in Jmeter
I want to compare 2 JDBC responses in Jmeter:
I have Source reponse from 1 JDBC request as below in table format:
(Source DB)JDBC Response response1:
srcid1 | srcid2 | srcid3| srcid4 |
10 | 20 | 30 | GBP |
11 | 22 | 31 | USD |
(Target DB)JDBC Reponse 2:
tgtid1 | tgtid2 | tgtid3 | tgtid4 |
10 | 20 | 30 | GBP |
11 | 22 | 31 | INR |
I am saving the response as String in JDBC Request (in Result Variable Name)
Now how do I compare the values in each column and Print Pass when values match. Fail it when the values do not match.
Number of rows can change.
Need help with assertion code or any other way this can be achieved in Jmeter.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×