Forum Discussion

SharadKoshal's avatar
SharadKoshal
New Contributor
8 years ago

Getting error message "unexpected end of file after null"

Hello, I am getting error "unexpected end of file after null" What i did? 1)Created/Added new JDBC request (test connection is successfull) 3)added sql query- it is getting fired and retrieving r...
nmrao's avatar
nmrao
Champion Level 3
You need to show the sample xml
SharadKoshal's avatar
SharadKoshal
New Contributor
8 years ago

Hello,

 

Issue was in reading response and parsing it.

What i did?


def jdbcXMLRequest = context.expand('${JDBC Request#Request}')
def jdbcXMLResponse = context.expand('${JDBC Request#ResponseAsXml}')
def xml = new XmlHolder(jdbcXMLResponse)

 

Read response as XML instead, then parsed it using XML Holder.

Then Did following for getting specific node value

def _XXX= xml.getNodeValue('//ResultSet/Row[1]/XXX')

log.info _XXX

 

This worked for me.

 

Thank you