Update Cascade In EOM in 2 level of many2many relationship
Update Cascade In EOM in 2 level of many2many relationship
- Subject: Update Cascade In EOM in 2 level of many2many relationship
- From: Buyung Pamungkas <email@hidden>
- Date: Mon, 14 Jul 2003 07:24:57 -0700 (PDT)
Dear,
I built a model like this :
Father >>---<<Mother (Many2many relation)
|
|
Child>>---<<ChildInLaw (Many2many relation)
|
|
Grand Child
Those model have an attributes like this :
Father
- pkFather (pk, auto number)
- name
Mother
- pkMother (pk, auto number)
- name
Child
- pkMother (pk, propagated from Mother)
- pkFather (pk, propagated from Father)
- name
ChildInLaw
- pkChildInLaw (pk, auto number)
- name
GrandChild
- pkMother (pk, propagated from Child)
- pkFather (pk, propagated from Child)
- pkChildInLaw(pk, propagated from ChildInLaw)
- name
FYI, I'm using WO 5.2, Oracle 8.1.7 and classes12.jar
as jdbc filez.
I have filled the tables with WOA. After I created a
Child entry from Father and Mother flattened
relationship, then I created a GrandChild entry from
Child and ChildInLaw. Hmm..2 level many2many
relationship.
So, when I wanna change Father from Child, An
integrity constraint required an error! Because it
have a child record in GrandChild.
I'm looking for the way to drive Update Cascade on
those cases but I didn't find a rule to do that. EOM
just provide delete cascade rule and propagated a key
when inserted.
It's costly for me to change a model because I will
deploy my app next week. So, I really need the way to
solve those problem. Another way that I would like to
do is create a trigger in Oracle that do "ON UPDATE
CASCADE". But I wonder it will work.
Please, give me some advice or knowledge to drive
those problem.
Thank you.
Regards,
Buyung
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.