Forum Discussion

rajs2020's avatar
rajs2020
Frequent Contributor
4 years ago

ReadyAPI - Return entire result set from a database ?

I have a run test case step in Test1 which calls a Test2. Test2 only has one JDBC step at the moment. I want to return the entire result set from Test2 to Test1, preferably in the form of a single "o...
  • HimanshuTayal's avatar
    HimanshuTayal
    4 years ago

    rajs2020 : you can do it by following way:

    //if in same Test Case

def teststep = testRunner.getTestCaseByName("TestCase2").getTestStepByName('JDBC Step')

//if in different Test Case

def teststep = testRunner.testCase.testSuite.getTestCaseByName("TestCase2").getTestStepByName('JDBC Step')

     

aaronpliu's avatar
aaronpliu
Frequent Contributor
4 years ago

Hi rajs2020 ,

 

JDBC return a xml-like response, you can think of it as XML response and use

import com.eviware.soapui.support.XmlHolder

def teststep = testRunner.testCase.testSteps['JDBC Step']
def response = teststep.testRequest.response.contentAsXml

def holder = new XmlHolder(response)
def node = holder.getNodeValues( "//aa/b" )

 

 

Thanks,

/Aaron

    • HimanshuTayal's avatar
      HimanshuTayal
      Community Hero
      4 years ago

      rajs2020 : you can do it by following way:

      //if in same Test Case

def teststep = testRunner.getTestCaseByName("TestCase2").getTestStepByName('JDBC Step')

//if in different Test Case

def teststep = testRunner.testCase.testSuite.getTestCaseByName("TestCase2").getTestStepByName('JDBC Step')

       

      • rajs2020's avatar
        rajs2020
        Frequent Contributor
        4 years ago

        HimanshuTayal- Thanks. I tried it, but could not get the Xpath to work.

        import com.eviware.soapui.support.XmlHolder;

def teststep = testRunner.testCase.testSuite.getTestCaseByName('GetDBData').getTestStepByName('GetData')
def response = teststep.testRequest.response.contentAsXml


def holder = new XmlHolder(response)
def xPathQuery = "//Results/ResultSet/Row[@rowNumber='2']"
def node = holder.getNodeValues(xPathQuery)
log.info(node.toString())


        I have tested my xpath on http://xpather.com/ and it is correct. So, why am I getting an array with only one empty string?