MQSeries.net :: View topic - How to get message loaded into Oracle?

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to get message loaded into Oracle?

How to get message loaded into Oracle?

« View previous topic :: View next topic »

Author

Message

Teckh

Posted: Tue Nov 14, 2006 2:32 pm Post subject: How to get message loaded into Oracle?

Newbie

Joined: 12 Oct 2006
Posts: 6

This may be a very simple question, I hope it is

Is there a way to use an insert SQL statement (or similar method) to load an entire message (in XML form) into Oracle as a string? The string would serve as a backup of the data.

The message must keep its XML format so that if it was loaded back onto a queue, a Jtext adapter would be able to parse it.

Any tips or suggestions would be greatly appreciated.

Thanks.

madi

Posted: Tue Nov 14, 2006 3:08 pm Post subject:

Chevalier

Joined: 17 Jan 2006
Posts: 475

sure u can ... u can just take it in as BLOB ... cast it into a string and then put it in a database

search for CAST from BLOB to string on the forum and u should find what u need

--madi

jefflowrey

Posted: Tue Nov 14, 2006 3:09 pm Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

Or just insert into Oracle as a CLOB directly...

Or use ASBITSTREAM to convert an XMLNSC message tree into a BLOB or string...

Or...

Or...
_________________
I am *not* the model of the modern major general.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to get message loaded into Oracle?

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP