| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| urgent!!!!! ask help about Message Flow design!!!! thanks. |
« View previous topic :: View next topic » |
| Author |
Message
|
| Jonasli |
 Posted: Mon May 12, 2003 7:15 pm Post subject: urgent!!!!! ask help about Message Flow design!!!! thanks. |
 |
|
Apprentice
Joined: 24 Apr 2003
Posts: 34
Location: Beijing
|
hi, WMQI masters.
i met a problem to design the message flow in the WMQI v2.1 + CSD03,
the input data as following,
01|JSZGGZ-03-3209|109||345E2492M0254|N
01|JSZGGZ-03-3210|109||345E2492M0255|N
01|JSZGGZ-03-3212|109||345E2492M0254|N
05|JSZGGZ-03-3209|109|30314171||2003-03-14
05|JSZGGZ-03-3212|109|30314171||2003-03-14
05|JSZGGZ-03-3212|109|30314172||2003-03-14
05|JSZGGZ-03-3212|109|30314173||2003-03-14
in the input data, there maybe have more rows end with <CR><LF>,
the row begin with '01' is meant to the header of logical data.
the row begin with '05' is meant to the body of logical data related with the above header row.
the header row maybe have body row in the below or not. and one header row maybe have one or more body row.
first assumed that the number of header and body filds is same number, (for example, there are 6 fields in above data).
now, i design the message set with TDS, can parse the input data, and input them into the database,
in the message flow, i want to parse the input data into individual messages and insert them into database by separated as the logical requirement as following 3 message,
and about inserting into database, need insert into different tables for header and body row, and keep the transaction for every mesages:
01|JSZGGZ-03-3209|109||345E2492M0254|N
05|JSZGGZ-03-3209|109|30314171||2003-03-14
01|JSZGGZ-03-3210|109||345E2492M0255|N
01|JSZGGZ-03-3212|109||345E2492M0254|N
05|JSZGGZ-03-3212|109|30314171||2003-03-14
05|JSZGGZ-03-3212|109|30314172||2003-03-14
05|JSZGGZ-03-3212|109|30314173||2003-03-14
Now, my design for message flow do the all thing(1. spilting 2. insert database) in one computer node,
but the disadvantage is that i can not control the individual rollback for individual message, must be the one inputed data.
which is unaccepted.
for Message Flow, my question is::::
. how to spilt the one message parsed from the input data into more message?
for i do not know the certainly numbers of individual message in the inpur data.
. how to repeat to deal the individual message into database after spilting one input message?
and just rollback and back the result of response for the fail of individual message to the original request client.
which node to use to do it?
experts, thanks in advanced, please give me some tips or discussion.^_^ |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue May 13, 2003 4:59 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| Quote: |
. how to spilt the one message parsed from the input data into more message?
for i do not know the certainly numbers of individual message in the inpur data. |
This is what the propagate command is for. Code a loop that goes through each group of records and set them as the output message, and then use propagate to pass each group out of one compute node as an individual message to the next compute node. The next compute node does your inserts.
| Quote: |
. how to repeat to deal the individual message into database after spilting one input message?
and just rollback and back the result of response for the fail of individual message to the original request client.
which node to use to do it? |
Once you're propagating your individual messages out, you can put in a try-catch node before your database insert, to allow you to handle each error individually without having to roll back the entire input message. Just remember that doing this does PREVENT you from rolling back the entire input message, without taking explicit action to rethrow an error back up to the input node. |
|
| Back to top |
|
|
| Jonasli |
| Posted: Tue May 13, 2003 5:47 pm Post subject: thanks, |
|
|
Apprentice
Joined: 24 Apr 2003
Posts: 34
Location: Beijing
|
hei, JeffLowery,
yeah, i tried it by ur advice, yeah, now i can do it, and doing it with more logic now, thanks very much,
and i also design other flow to implement it,
use Environment tree to remember some value about header and body,
then use the FlowOrder node to spilt the original message.
and loop by the flow connector.
but compare to ur advice, wow. such easy to implement by ur advice,
sure, u are a master, thanks again, |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed May 14, 2003 11:52 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
What? When did that happen? 
I coulda sworn I was an acoloyte last week... 
Nahh. I'm just another WMQI hacker. |
|
| Back to top |
|
|
| Jonasli |
| Posted: Thu May 22, 2003 12:43 am Post subject: |
|
|
Apprentice
Joined: 24 Apr 2003
Posts: 34
Location: Beijing
|
hi, Jeff,
^_^, thanks u very much la. 
i was packaged with customer project recently, did not see ur reply.^_^,
great, hacker must be a master firstly, thanks, ^_^
nice days. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
