| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Do MQ provide the trigger and message removal |
« View previous topic :: View next topic » |
| Author |
Message
|
| pradeepr |
 Posted: Wed Apr 09, 2003 9:21 am Post subject: Do MQ provide the trigger and message removal |
 |
|
Newbie
Joined: 09 Apr 2003
Posts: 1
|
Hi All,
I have following queries.
1. I am having application A running.Whenever there is any change in the application A database,I should able to put the message on the MQ which will deliever and update the other application database.
My restriction is that I should not change the Application A code.
Can I provide the trigger from the database OR is there any other solution.
2. How the messages are removed.Should it done manaully or by queue manager.
Regards,
Pradeep |
|
| Back to top |
|
 |
| mqonnet |
| Posted: Wed Apr 09, 2003 10:10 am Post subject: |
|
|
Grand Master
Joined: 18 Feb 2002
Posts: 1114
Location: Boston, Ma, Usa.
|
Triggering is an option but not in the first stage.
Stage 1: You have to have an application or some way of putting a message onto a queue that has triggering set to say that there was a new update to the DB.
Stage 2: The message when put on the local queue with all the trigger conditions met, would generate a trigger message and invoke the application you wish to trigger. This app should then retrieve the message and update the App b Database.
Message would be removed as part of stage 2 processing by your app b.
Hope this helps.
Cheers
Kumar
_________________
IBM Certified WebSphere MQ V5.3 Developer
IBM Certified WebSphere MQ V5.3 Solution Designer
IBM Certified WebSphere MQ V5.3 System Administrator |
|
| Back to top |
|
|
| vennela |
| Posted: Wed Apr 09, 2003 11:31 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
Pradeep:
Let me add to what Kumar said.
There are DataBase triggers that would invoke applications when there is an update or insert or delete etc depending on what your DB is. I know there are triggersfor DB2 and Oracle and most likely there are triggers for other popular databases too. The application that is invoked by the database trigger can be something that would PUT a message to a queue. This message can go anywhere (may be to another machine on a different platform ).
When there is a message either
1. you can have an app running perpetually to read and process (do DB updates etc) the message
2. Trigger (this is MQ trigger) an app to process the message.
If your database is Oracle, all this is done through a product sold by Oracle and it is called Oracle MQ adapter.
-------
Venny |
|
| 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
|
|
|
|
