Forum Discussion

Asubbiah's avatar
Asubbiah
Contributor
9 years ago

validating REST response against JDBC response

Hi,   I have to compare the Rest response with JDBC result set. I am following the below steps.   1. Datasource - JDBC - Run the query and get the values 2. Rest Step - Execute and get the resp...
  • Asubbiah's avatar
    Asubbiah
    Contributor
    9 years ago

    Hi Rao,

     

    I am able to compare my rest response with the JDBC results referencing the link you provided. 

     

    Now, I have the JDBC test step in a different test case. How can i get the JDBC response from that test case? Currently I am using,

     

    def jdbcResponse = context.expand('${JdbcStepName#ResponseAsXml}

     

    Since, I have this script added to my script assertion, I am not able to use testRunner.

    • nmrao's avatar
      nmrao
      Champion Level 3
      9 years ago
      Sorry, it is not really clear. Would you like to describe the structure of the test case with details? or the script that you have problem?
      • Asubbiah's avatar
        Asubbiah
        Contributor
        9 years ago

        Test case 1 has JDBC test Step which runs select query and gets the response

         

        Test case 2 has Rest test step.

         

        I have added a script assertion in the Rest test step to compare the response with the Testcase 1-JDBC test step response.

        I have referred your groovy script http://stackoverflow.com/questions/31472381/dynamically-compare-rest-xml-json-response-and-jdbc-usin... and implemented here.

         

        When I have the JDBC and REST test steps in the same testcase, I am able to successfully compare the responses. 

        But when they are in different test case, what should i add instead of def jdbcResponse = context.expand('${JdbcStepName#Response}'