DB resultset into property


Article ID: 74942


Updated On:


CA Application Test Service Virtualization CA Continuous Application Insight (PathFinder)


I am doing a JDBC query against Oracle Database, and it returns a json result set.  Is there a property to save entire JDBC result set into property? 

When we fire the JDBC query, DevTest creates an XML document. Inside the document is an element that represents each row in the Resultset. When the Result set returns XML  the step response will be seen in  <StepName.rsp> property. But if the result set is json , converting the XML to JSON means that the is not going to be very descriptive. You might see extra characters in the step response. The characters are Unicode Hex values representing carriage returns.



All supported DevTest environments. 


1. Use individual filters for each of those values. 
2.Add a Java Script step and send the response from the query to a Java Script code and do the conversion in the code.