MQSeries.net :: View topic - How to know how many records are updated within Compute node

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 know how many records are updated within Compute node

How to know how many records are updated within Compute node

« View previous topic :: View next topic »

Author

Message

satya2481

Posted: Sun Aug 31, 2014 2:29 pm Post subject: How to know how many records are updated within Compute node

Disciple

Joined: 26 Apr 2007
Posts: 170
Location: Bengaluru

Hi All,
I have a requirement to build a retry logic based on whether the particular record is updated in the table or not. My design is as shown below with 2 independent flows which are multi threaded.

Code:

Request Mesage flow
MQInput -> ComputeNode -> Send request to Insert request record -> Send message to Backend
Response Message flow
MQInput -> ComputeNode -> Send request to Update the status of inserted record -> Check if all the rows associated with that group completed or not -> Send the response back to client
DB Flow
MQInput -> Insert the records
MQInput -> Update the records

If I make all the flows are multi threaded then I will not be sure if Insert happens only before Update operation.
If I perform Update operation first before Insert is done then it will fail entire design. So in order to over come this situation I wanted to know if Update really updated any records, if it is not updated any records then retry that update operation.

Let me know if anyone has any inputs on this to know how many records are updated in table from within the Compute node.

Regards
Satya

fjb_saper

Posted: Sun Aug 31, 2014 4:18 pm Post subject:

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20696
Location: LI,NY

One question to you: What happens when an update fails on the DB? How is that reflected in the flow? ...

_________________
MQ & Broker admin

satya2481

Posted: Mon Sep 01, 2014 3:22 am Post subject:

Disciple

Joined: 26 Apr 2007
Posts: 170
Location: Bengaluru

Code:

What happens when an update fails on the DB? How is that reflected in the flow?

In this case I am expecting SQL error will be thrown from the DB and it will be handled in the flow.
My query is to know how many records are updated by the UPDATE flow. Based on this result I can decide whether I have to retry in my flow for UPDATE operation or not.
Hope this is clear now....

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to know how many records are updated within Compute node

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