DB resultset into property

book

Article ID: 74942

calendar_today

Updated On:

Products

CA Application Test Service Virtualization CA Continuous Application Insight (PathFinder) CA Service Virtualization (DevTest / LISA / VSE / Application Test)

Issue/Introduction

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.

 

Environment

All supported DevTest environments. 

Resolution

Resolution:
************
1. Use individual filters for each of those values. 
OR
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.