| Author |
Message
|
| gus |
 Posted: Tue Dec 31, 2002 1:22 pm Post subject: Saving XML tree for later use |
 |
|
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 |
|
 |
| lung |
| Posted: Wed Jan 01, 2003 4:52 pm Post subject: |
|
|
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 |
|
|
| gus |
| Posted: Thu Jan 02, 2003 5:28 am Post subject: |
|
|
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 |
|
|
| lung |
| Posted: Thu Jan 02, 2003 4:41 pm Post subject: |
|
|
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 |
|
|
| warrenpage |
| Posted: Thu Jan 02, 2003 5:04 pm Post subject: |
|
|
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 |
|
|
| gus |
| Posted: Fri Jan 03, 2003 4:01 am Post subject: |
|
|
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 |
|
|
| jsware |
| Posted: Sun Jan 05, 2003 9:52 am Post subject: |
|
|
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 |
|
|
| MVO |
| Posted: Tue Jan 07, 2003 6:59 am Post subject: |
|
|
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 |
|
|
|
|
