Forum Discussion

testhrishi's avatar
testhrishi
Frequent Contributor
9 years ago

What is a better way to validate the response coming back from JDBC request?

What is the best way to validate the response coming back from JDBC request?   CONTAINS assertion may not validate the case where more than expected data comes back in response. Contains will stil...
testhrishi's avatar
testhrishi
Frequent Contributor
9 years ago

In this case entire JDBC response

Radford's avatar
Radford
Super Contributor
9 years ago

I've always run into issues when I used to attempt to match the entire response. Can you just assert the individual fields in the returned JDBC XML response?

  • testhrishi's avatar
    testhrishi
    Frequent Contributor
    9 years ago

    In my case its the JSON thats coming back. Although I am asserting on expected individual field value, it does not guarantee to test if unwanted stuff comes back along with it. In other words its not full proof

     

    • Radford's avatar
      Radford
      Super Contributor
      9 years ago

      I'm very sorry I can't quite picture your JDBC respose data, is it possible for you to attach a sample of your data here? It doesn't matter is you have to obscure the data field contents it's more the structure I was interested in.

      • testhrishi's avatar
        testhrishi
        Frequent Contributor
        9 years ago

        Here you go-

        [{"f":"TEST_ZIP","s":"1","t":101010101},{"f":"TEST_CITY","s":"1","t":20202002},{"f":"TEST_COUNTRY","s":"1","t":303030303},{"f":"TEST_NAME","s":"1","t":404040404}]