Compare 2 JDBC response in Jmeter

Question

I want to compare 2 JDBC responses:

I have Source reponse from 1 JDBC request as below in table format:

(Source DB)JDBC Response response1:

(Target DB)JDBC Reponse 2:

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.

Answer 1

Assuming you define Result variable name as result1 for first JDBC Request sampler

and define Result variable name as result2 for the second JDBC Request sampler you would be able to compare the result sets using JSR223 Assertion and the following code:

def result1 = vars.getObject('result1')
def result2 = vars.getObject('result2')

def equal = (result1 == result2)

if (!equal) {
    AssertionResult.setFailure(true)
    AssertionResult.setFailureMessage('result1' + (result1 as String) + System.getProperty('line.separator') + 'result2: ' + (result2 as String))   
}