ReadyAPI - Return entire result set from a database ?

Question

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 "object". How do I do that? How do I access the rows and columns in that "object" via a groovy script? Something like this:

Test 2 - JDBC step :
return TableLikeObject or Json.

Test1 - Groovy test step :
TableLikeObject table = Test 2 - JDBC returned value.
table.getRow(1).getColumn('Employee name')

Test1 calls Test2.

himanshutayal · Accepted Answer

rajs2020&nbsp;: 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')
&nbsp;

nmrao · Answer

1. Create a test case level custom property for Test2. Say JDBCRESPONSE.
2. Set the value to above property when jdbc step is run.
3. In Test1, add a "Run Test Case" step, the wizard allows which Return Properties you want from Test 2.&nbsp;

aaronpliu · Answer

Hi rajs2020 ,&nbsp;JDBC return a xml-like response, you can think of it as XML response and useimport 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" )&nbsp;&nbsp;Thanks,/Aaron

sonya_m · Answer

Thank you for the suggestion&nbsp;nmrao&nbsp;
&nbsp;
rajs2020&nbsp;Was the advice helpful?

rajs2020 · Answer

aaronpliu&nbsp;- thanks.def teststep = testRunner.testCase.testSteps['JDBC Step']Instead of doing that, how do I do this:def teststep = testRunner.testCase["TestCase2"].testSteps['JDBC Step']I saw some documentation, but its not quickly clear how I can do something like that.https://www.soapui.org/docs/scripting-and-properties/tips-tricks/&nbsp;&nbsp;

rajs2020 · Answer

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?

Forum Discussion

ReadyAPI - Return entire result set from a database ?

6 Replies

Related Content

ReadyAPI and TestEngine with Zephyr Scale

ReadyAPI and TestEngine with Zephyr Scale

How to get database password in ReadyAPI?

ReadyAPI freezes when trying to connect to oracle database

ReadyAPI - Understanding the result returned by a groovy script?

Recent Discussions

JDBC results are stored in the ReadyAPI project

Azure Git Integration?

How to run specific test case in particular environment?

How to remove (not clear) test case properties from SaveScript

Parameterising JDBC Connection Settings..Can you do it?