1 Reply Latest reply: Jul 28, 2012 6:02 PM by DrClap RSS

    XPath in JDK1.4 - Please help

    user10177353
      Hi There,
      Can some one help me with the code for XPath in JDK1.4.2 I have a scenario where I would get the XML Message from Tibco EMS Message as a String. I should parse the XML into a PL/SQL Record type. i.e., Each of the Name/Value tags below would become a Column and Value for PL/SQL Record type.
      If you have a better approach please advice.

      Below is the XML I would get from EMS Message.

      <?xml version="1.0" encoding="UTF-8"?>
      <SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
      xmlns:xsd="http://www.w3.org/2001/XMLSchema"
      xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
      xmlns="http://emsapp/InvoiceOrderStatusNotification">
      <SOAP-ENV:Body>
      <invoiceOrderStatusNotification>
      <invoiceOrderStatusNotificationMessage>
      <sourceSystem>
      <sourceSystemType>Invoice Order Manager</sourceSystemType>
      <sourceSystemId>INVOICE-APP</sourceSystemId>
      </sourceSystem>
      <alternativeIdentifiers>
      <alternativeIdentifier>
      <name>invoiceNumber</name>
      <value>0312345678</value>
      </alternativeIdentifier>
      <alternativeIdentifier>
      <name>orderNumber</name>
      <value>12345678</value>
      </alternativeIdentifier>
      </alternativeIdentifiers>
      <characteristics>
      <characteristic>
      <name>invoiceDateTime</name>
      <value>20120613123625</value>
      </characteristic>
      <characteristic>
      <name>invoiceMethod</name>
      <value>MAN</value>
      </characteristic>
      </characteristics>
      </invoiceOrderStatusNotificationMessage>
      </invoiceOrderStatusNotification>
      </SOAP-ENV:Body>
      </SOAP-ENV:Envelope>

      Please help, thanks in advance.
      PS: I have to achieve it in JDK1.4.2 as my produciton is currently running on JDK1.4.2 :(

      Edited by: user10177353 on Jul 29, 2012 2:35 AM