search cancel

DB result set into property

book

Article ID: 74942

calendar_today

Updated On:

Products

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

Issue/Introduction

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 the JDBC query is made, 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. There might be an extra characters in the step response. The characters are Unicode Hex values representing carriage returns.

 

Cause

N/A

Environment

All supported DevTest releases.

Resolution


1. Use individual filters for each of those values. 


OR


2.Add a Javascript step and send the response from the query to a Java Script code and do the conversion in the code.