Hi All,
A newbie to this fourm hoping for some help. Below is the scenario I have and should implement in Java would be a eaiser way. Therefore please help me. Helping with the Code would be much helpful since I'm a novice to Java. By the way the JDK ver is 1.2
1) We get a XML data into the Websphere MQ.
2) Our program (preferrably Java) pools the MQ and reads the XML.
3) Parse the XML and Insert into a Staging table in Oracle.
The XML data will be as below
<?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://application/StatusNotification"> <SOAP-ENV:Body> <StatusNotification> <StatusNotificationMessage> <sourceSystem> <sourceSystemType>Somewhere</sourceSystemType> <sourceSystemId>MySystem</sourceSystemId> </sourceSystem> <alternativeIdentifiers> <alternativeIdentifier> <name>employeeNumber</name> <value>1234567890</value> </alternativeIdentifier> <alternativeIdentifier> <name>departmentNumber</name> <value>12345678</value> </alternativeIdentifier> </alternativeIdentifiers> <characteristics> <characteristic> <name>swipeDateTime</name> <value>20120613123625</value> </characteristic> <characteristic> <name>role</name> <value>MAN</value> </characteristic> </characteristics> </StatusNotificationMessage> </StatusNotification> </SOAP-ENV:Body> </SOAP-ENV:Envelope>
The Data that should be inserted into Staging table should be:
employeeNumber departmentNumber swipeDate role -------------- ---------------- ------------ ----- 1234567890 12345678 13-JUN-12 MAN