December 19, 2005 at 10:28 am
There is one ParentTable and there are five ChildTables.
ParentTable is related to ChildTables with one-to-many relations.
If any changes happened, I need to send a message to some service (outside world) that contains the whole “family” info (parent record and all related child records).
I can catch changes only using DB triggers. 6 triggers send 6 messages to intermediate service. I want to correlate these 6 messages to handle them at once and to send just one message to outside world. (Triggers send just a pointer to modified “family” and intermediate service asynchronously builds the final message)
Service Broker can do messages correlation only using 1) conversation or 2) conversation group and nothing else, correct? But the triggers run in unpredictable order and, may be, not all of them. I don’t have a possibility (a right moment) to open/close new dialog.
How can I implement message correlation with multiple writers (triggers)?
Please advice.
December 28, 2005 at 8:01 am
Looks like it's impossible with current Service Broker functionality.
By the way, I was able to implement such functionality in Oracle environment using AQ messaging system.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply