ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Saving XML tree for later use

Post new topic  Reply to topic
 Saving XML tree for later use « View previous topic :: View next topic » 
Author Message
gus
PostPosted: Tue Dec 31, 2002 1:22 pm    Post subject: Saving XML tree for later use Reply with quote

Apprentice

Joined: 10 Apr 2002
Posts: 36

I am currently usint the PostIt PlugIn for the saving of the XML tree when I make a call to CICS. It has been working pretty good. But once in a while it will have problems and cause the execution group to get a failure over and over which causes the request messages to not be serviced. What is the best way to save off the XML tree for later use.

Thanks
Back to top
View user's profile Send private message
lung
PostPosted: Wed Jan 01, 2003 4:52 pm    Post subject: Reply with quote

Master

Joined: 27 Aug 2002
Posts: 291
Location: Malaysia

You can save the data into a DB2 database first. (using the Database node)

_________________
lung
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger MSN Messenger
gus
PostPosted: Thu Jan 02, 2003 5:28 am    Post subject: Reply with quote

Apprentice

Joined: 10 Apr 2002
Posts: 36

Thanks for the input. My problem with that is I do not know the XML tree structure. It is build dynamically so do I convert this into a BLOB first then insert into the database using the MsgId as the key then convert back to a STRING ????? The tree is built on the number of accounts each customer has so there is no way to create a database with the known fields. I have tried using the database before but with on luck. I must be doing something wrong. Any help on this would be great.

Thanks Gus
Back to top
View user's profile Send private message
lung
PostPosted: Thu Jan 02, 2003 4:41 pm    Post subject: Reply with quote

Master

Joined: 27 Aug 2002
Posts: 291
Location: Malaysia

gus wrote:
It is build dynamically so do I convert this into a BLOB first then insert into the database using the MsgId as the key then convert back to a STRING ?????

Yes, I think that might just work. Haven't try it out myself, though.
_________________
lung
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger MSN Messenger
warrenpage
PostPosted: Thu Jan 02, 2003 5:04 pm    Post subject: Reply with quote

Acolyte

Joined: 19 Feb 2002
Posts: 56
Location: Australia

define a table with a CLOB/BLOB column then


SAVE THE MESSAGE using
=================

PASSTHRU('INSERT INTO DB_MESSAGE_STORE
(Key,
MSG_XML_TX)
VALUES (?, ?)',
uniqTranID,
BITSTREAM(OutputRoot.XML));

Get the Message using
==============

DECLARE pairingKey CHARACTER;
SET pairingKey = Environment.KEYS.pairingKey;

SET Environment.TMP.blob[] =
PASSTHRU('SELECT BLOB(M.MSG_XML_TX) AS TX
FROM DB_MESSAGE_STORE AS M
WHERE M.KEY = ?
,pairingKey);

CREATE FIRSTCHILD OF Environment.TMP.TRAN DOMAIN 'XML' PARSE(Environment.TMP.blob.*[1]);

SET OutputRoot.XML = Environment.TMP.TRAN.XML;

SET Environment.TMP = NULL;
Back to top
View user's profile Send private message Yahoo Messenger MSN Messenger
gus
PostPosted: Fri Jan 03, 2003 4:01 am    Post subject: Reply with quote

Apprentice

Joined: 10 Apr 2002
Posts: 36

Great, I will try that today. Thanks again for your help. You have a great day and a great weekend.

Gus
Back to top
View user's profile Send private message
jsware
PostPosted: Sun Jan 05, 2003 9:52 am    Post subject: Reply with quote

Chevalier

Joined: 17 May 2001
Posts: 455

I've successfully save messages to a cache queue and retrieved them using the MQGet plugin.

It works fine and is really fast and you don't need any extra processes to clean up expired messages from a database table.
Back to top
View user's profile Send private message
MVO
PostPosted: Tue Jan 07, 2003 6:59 am    Post subject: Reply with quote

Centurion

Joined: 09 Sep 2001
Posts: 131

I also used the PostIt node to save/retrieve ReplyToQ info. I tried to replace PostIt with MQGet but found that MQGet is inconsistent, at least on Solaris. It does not always work. Anyone experienced the same problem ?
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Saving XML tree for later use
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
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.