How to Compare 2 JDBC response in Jmeter

Posted on March 5, 2019

Databases

Java

By Mayank89

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:

src_id1 | src_id2 | src_id3| src_id4 |

tgt_id1 | tgt_id2 | tgt_id3 | tgt_id4 |

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.

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

jarland

March 22, 2019

Greetings!

It sounds like you’re pulling values from a database and want to perform an operation on them with jmeter. I may be misunderstanding, so please correct me if you see that I am. I see jmeter as a load testing application, rather than something that would be ideal for performing operations on database queries.

I believe that the tool you require to compare these values would be something custom coded. I, for example, would probably do it in Python or a bash script because those are my specialties.

Jarland