Forum Discussion
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
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/*}
Related Content
- 7 years agoHappyRandom
- 6 years agopankajmalinda
Recent Discussions
- 5 days agoruchisingh