Blank JDBC response when saved to a file

[Rakesh15]

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.

[ChrisAdams]

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.

[Rakesh15]

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

[ChrisAdams]

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.

[richie]

Hey @Rakesh15 

have you tried adding logging into your script?

i.e. on the next line after 'def Res = context.expand( '${JDBC#Response}' )'

insert 'log.info(Res)'  //adding this should indicate the contents of the Res variable 

so your code reads:

def Res = context.expand( '${JDBC#Response}' )

log.info(Res)
def j = new File(ResFile)

if the file is created fine then it seems logical think the step in the code that passes the content to the variable or the line extracting the value from the variable is where the issues lies adding the log.info (Res) line should help tell us if the response is being passed into the Res variable correctly

Also - I've had trouble with JDBC steps in groovy scripting before now - when I wanted the contents of the query results I found  context.expand('${JDBC#Response}') didn't always work, however if I changed this to context.expand ( '${JDBC Request#ResponseAsXml#//Results/*}' ).

ta

rich

${JDBC Request#ResponseAsXml#//Results/*}

[Rakesh15]

I was able to resolve the issue

[richie]

Hey @Rakesh15,

Would you mind detailing how you fixed the issue so that if anyone has the same issue they can fix it also?

Cheers,

Rich