Lists

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

Re: Foreign Key Constraints and EOModeler

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Foreign Key Constraints and EOModeler

Subject: Re: Foreign Key Constraints and EOModeler
From: James Brook <email@hidden>
Date: Wed, 21 Nov 2007 19:20:39 +0100


On 21 Nov 2007, at 16:56, Jeffrey Simpson wrote:

I have been told that when using EOModeler you cannot have Foreign Key
Constraints.  Is this true?  Does anyone use them?

We use them with Oracle. I think it depends on the database you use. You need to make sure that the constraints are not applied immediately. If you commit several operations with EOF, you don't know what order they will be applied in and the constraints can break things. With Oracle this can be achieved by making sure that your constraints are applied with 'INITIALLY DEFERRED DEFERRABLE'. Be careful with cascade deletes though, because EOF snapshots do not like having objects deleted from underneath them.

--
James
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden



References:  
  >Foreign Key Constraints and EOModeler (From: Jeffrey Simpson <email@hidden>)




Prev by Date:
Re: WO 5.4 templateWithHTMLString ?

Next by Date:
Re: Foreign Key Constraints and EOModeler

Previous by thread:
Foreign Key Constraints and EOModeler

Next by thread:
Re: Foreign Key Constraints and EOModeler

Index(es):

Date
Thread