Forum Discussion

SharadKoshal's avatar
SharadKoshal
New Contributor
9 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
9 years ago
You need to show the sample xml
  • SharadKoshal's avatar
    SharadKoshal
    New Contributor
    9 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

Related Content