Re: Foreign Key Constraints and EOModeler
Re: Foreign Key Constraints and EOModeler
- Subject: Re: Foreign Key Constraints and EOModeler
- From: Chuck Hill <email@hidden>
- Date: Wed, 21 Nov 2007 10:54:28 -0800
Not! Well, not exactly. The work just fine with two notable
exceptions:
1. If you are using a super fine SQL database (and I use the term
database loosely here) like MS SQL Server from a vendor who still
rails against constraint handling ("It's wrong! We're right!")
accepted as a standard (see SQL92) for the last 15 years or who just
can't get it together to implement deferrable constraint handling,
well, then FK constraints might not work so well. Unless... you use
Project Wonder* and include this line in your main() method:
ERXDatabaseContextMulticastingDelegate.addDefaultDelegate(new
ERXEntityDependencyOrderingDelegate());
2. You have a really stupid legacy schema or like pain a lot and use
Horizontal Inheritance (which IIRC even the EOF masochist LD does not
use... yet), in which case FK constraints are impossible to enforce
at the database level.
Chuck
* Project Wonder fixes almost everything except World Peace.
On Nov 21, 2007, at 10:24 AM, Mike Schrag wrote:
FK constraints work just fine ...
ms
On Nov 21, 2007, at 10:56 AM, Jeffrey Simpson wrote:
I have been told that when using EOModeler you cannot have Foreign
Key
Constraints. Is this true? Does anyone use them?
Jeffrey Simpson
Youth For Understanding USA
Preparing young people for their responsibilities and
opportunities in a
changing, interdependent world.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40mdimension.com
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40global-village.net
This email sent to email@hidden
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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