Blank JDBC response when saved to a file
The JDBC results are blank when saved in SOAP/REST UI 5.5. The result set has only is 1 or 2 lines
Looking for solutions.
Forum Discussion
HI,
Would you like to provide some more details about what you are trying to achieve and what you expect to happen. Screenshots would be really helpful too.
Step 1: I am able to fetch the results using JDBC query
Step 2: Able to export the file to local machine
Step3. My file is blank with no data
Below is the snippet I am using
def ReqFile ="C:/Test/ReqFile1.xml"
def Req = context.expand( '${JDBC#Request}' )
def i = new File(ReqFile )
i.write(Req, "UTF-8")
def ResFile ="C:/Test/Response1.xml"
def Res = context.expand( '${JDBC#Response}' )
def j = new File(ResFile)
j.write(Res, "UTF-8")Below is the JDBC request and output
Note: Important I need the Results/Response set to be stored in local
Hi,
That's much clearer, thank you. I understand what you're after now.
I don't have the means to test until Monday, but in the meantime, have you tried reporting the request and response of Rest/Soap web service call? If your Groovy works with one of those steps, then maybe there is something different about the JDBC step.
