| Author |
Message
|
| James_2007 |
 Posted: Tue Apr 19, 2011 9:54 pm Post subject: How database changes are refleted to message broker? |
 |
|
Newbie
Joined: 19 Apr 2011
Posts: 2
|
Hi,
I am having a scenorio like when any database changes are occured I have to get a message to the queue using message broker.
For eg.., When any update is done in the table in database I have to get one message like "Successfully updated".
Thanks in advance for all ur help and support. |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Tue Apr 19, 2011 10:42 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
whats the broker version?
are you updating the DB or some other application is updating the DB?
incase if broker is updating the DB; you can set the transaction and look for the return status.
if some one else is updating the DB and you need the status, then broker is not the right choice for this scenario.
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Apr 20, 2011 1:39 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Broker v7 has a DatabaseInput node...  |
|
| Back to top |
|
|
| James_2007 |
| Posted: Wed Apr 20, 2011 2:04 am Post subject: |
|
|
Newbie
Joined: 19 Apr 2011
Posts: 2
|
Thanks for ur Raply...
But we are using Version 6.0.... |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Apr 20, 2011 2:28 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| James_2007 wrote: |
Thanks for ur Raply...
But we are using Version 6.0.... |
Then you have another reason to upgrade to v7, as well as the fact that v6.0 goes out of support in less than two weeks.
You can't do this in Broker v6 without either writing a lot of really complicated code or using the JDBC Adapter, which requires a lot of setup and customization.
So just do the right thing and upgrade to v7 and use the DatabaseInput node. It is the least work for the best result. |
|
| Back to top |
|
|
|
|
