MQSeries.net :: View topic - Hello

sg94k6r2 · Posted: Mon Mar 07, 2005 2:36 pm Post subject:

Hello Everybody,

I have the following requirements:

An XML Meassage arrives at a local queue - read the message (not the MQ header just the content string). Do some validation and insert the xml data into a database table. Database table column names are the same as XML Tag names (1:1 mapping). If insert or validation fails - write message to error queue otherwise write it to the processed log queue.

I know how to read message off the queue and do validation/write to otther queues.

I am torn between using trigger or just a generic java app that pings the queue every so often.

Also, is there an easier way to map xml datafileds directly into database tables in MQ?

Does anyone have a better idea than what I intend to do as above?

Any comments will be well apprecieated.

Thank you very much!

Regards.