Topic
  • 1 reply
  • Latest Post - ‏2013-03-26T11:41:18Z by SystemAdmin
SystemAdmin
SystemAdmin
8523 Posts

Pinned topic Database Node

‏2013-03-21T20:48:53Z |
Hi Guys, I am new to message broker and I need some help with it.

I created a log table for auditing purposes and I wanted to store some information.

How can I save the XML message into a database field like the one below?
Sample Input Message
<testmsg><field1>10001000</field1><field2>8737368</field2><field3>111111</field3><field4>111111</field4><field5>This is a test</field5></testmsg>

Also how can I get the Correlation ID and Message ID from the message to store in a table.

Im trying to achieve this using ESQL

Log Table Fields
Message_ID
Coerelation_ID
Message (XML Message that was sent)

DB
Updated on 2013-03-26T11:41:18Z at 2013-03-26T11:41:18Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    8523 Posts

    Re: Database Node

    ‏2013-03-26T11:41:18Z  
    You might have more luck posting this on the "WebSphere Message Broker" forum?

    All the forums are listed here:-
    https://www.ibm.com/developerworks/forums/wsdd_forums.jspa

    Cheers
    Morag