Re: Foreign Key Constraints
Re: Foreign Key Constraints
- Subject: Re: Foreign Key Constraints
- From: Chuck Hill <email@hidden>
- Date: Tue, 9 May 2006 20:53:02 -0700
On May 9, 2006, at 8:45 PM, Dave Elsner wrote:
Hi,
I'm generating Foreign Key Constraints from with in EO Modeler, but
due to Oracles limitation of 30 character long identifiers
That is so 1972. :-P
most of my relationship constraints exceed this limit, so I need to
shorten them. If I Edit the SQL generated from EO Modeler from:
ALTER TABLE FOO ADD CONSTRAINT FOO_SOME_REALLY_REALLY_LONG_NAME_FK
FOREIGN KEY .........
To:
ALTER TABLE FOO ADD CONSTRAINT FOO_BAR_FK FOREIGN KEY .........
Will this affect how WO and the DB talk... My guess is No. That
once the constraints are created in the DB WebObjects doesn't
reefer to them ever again. But instead uses the EOModel rules. e.g.
it executes the SQL and if it violates a model rule it give an
error otherwise it sends the SQL to the DB and if it violates a DB
constraint then an exception is returned from the DB and has
nothing to do with the model. Right? So in other words I can
rename my Foreign Key Constraints to anything I like and every
thing will still work as per usual.
Yes, you can rename them as long as you are not using schema
synchronization. I am not sure how this would affect schema
synchronization.
Chuck
--
Coming in 2006 - an introduction to web applications using WebObjects
and Xcode http://www.global-village.net/wointro
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