| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How to report what content has been "deleted" or & |
« View previous topic :: View next topic » |
| Author |
Message
|
| lamtbs |
 Posted: Sat Apr 01, 2006 5:57 pm Post subject: How to report what content has been "deleted" or & |
 |
|
Acolyte
Joined: 07 Nov 2005
Posts: 57
Location: Hong Kong
|
Hi all,
The thing I want to archive is
1. A BO (row in a db table) may be inserted, deleted, or updated in a CUSTOMER table
2. Once this is detected, the adapter will create the <verb><BO> and pass it to Message Broker
3. Message Broker is supposed to report what has been inserted / deleted / updated with the before & after value
I've set DB2 trigger to
>insert into XWORLDS_EVENTS
>insert into the CHANGES_TABLE the key, old & new values
I've then ODA create a BO called "CHANGES" fromt the TN=CHANGES_TABLE
However, I found that the "Delete" Verb will simply set everything to "CXIgnore" except just the key field. So, How am I suppose to record what (content) was actually deleted?
Also, this design seems NOT to be the normal concept of a "BO" (like "customer", "order"), how should I have design this otherwise?
Thanks! |
|
| Back to top |
|
 |
| emiddleware |
| Posted: Thu Apr 06, 2006 5:50 pm Post subject: |
|
|
Centurion
Joined: 03 Apr 2006
Posts: 120
|
Hi,
In the table , TN = CHANGES_TABLE , do you have a field "Verb" ?
Anyways, to my knowlwedge , if there is a delete verb , the agent will only set the key values and others as "CxIgnore".
What I suggest is , since you want to know what data was deleted , you just use an indication say ,"D" and keep the verb as "Create" only . Coz , ultimately , thru ODA you are going to extract the data from CHANGES_TABLE and just want to know what data has been inserted, updated or deleted.
Let us know, if it would help .
_________________
Best Regards,
E-MiddleWare |
|
| Back to top |
|
|
| emiddleware |
| Posted: Thu Apr 06, 2006 6:06 pm Post subject: |
|
|
Centurion
Joined: 03 Apr 2006
Posts: 120
|
Dear Lamtbs,
Can you tell what all fields you are using in TN=Change_Table. Pls also mention what fields you are using in Customer_table, so that I can try out and let you know . You can also mail to emiddleware@gmail.com
_________________
Best Regards,
E-MiddleWare |
|
| Back to top |
|
|
| lamtbs |
| Posted: Sun Apr 09, 2006 2:31 am Post subject: |
|
|
Acolyte
Joined: 07 Nov 2005
Posts: 57
Location: Hong Kong
|
Hi,
thanks for the comments, seem this is the best way to go so far, have all the changes recorded in a CHANGE_TABLE (including whether the record is being updated/inserted/deleted, before/after value), and use a 'create' verb all the time for the CHANGE_TABLE (as it is always a insert new row in the CHANGE_TABLE).
I do agree this works, just I feel is not as neat as the <Verb><BO> in the original design of CrossWorlds :-p
I don't understand why the manual mention the CxIgnore behaviour in the "Delete" verb can be unset , and yet no document mention actually HOW?!! 
Thanks! |
|
| Back to top |
|
|
| emiddleware |
| Posted: Sun Apr 09, 2006 6:00 pm Post subject: |
|
|
Centurion
Joined: 03 Apr 2006
Posts: 120
|
Hi lambts,
I am able to undersand your problem but I would be more clear if I try this out . I would like to do a small experiment of the same scenario as you did. But I have SQL as repository and DB2 . Shall we try out using dummy tables . Can you write the trigger in SQL and send me so that I can try the same scenario with dummy tables and dummy values.
_________________
Best Regards,
E-MiddleWare |
|
| 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
|
|
|
|
