RE: Cascade delete with optional to-one relationship
RE: Cascade delete with optional to-one relationship
- Subject: RE: Cascade delete with optional to-one relationship
- From: "Albert Jagnow" <email@hidden>
- Date: Tue, 21 Oct 2003 09:09:32 -0500
- Priority: normal
- Thread-topic: Cascade delete with optional to-one relationship
Thanks for the help guys. I was able to solve the problem. The table B
FK was null for these objects so the data looked fine in the database.
However the table B FK column was not what EOModeler was using for the
join. You think I would have noticed the column name was wrong sooner
but I guess not. I had the table B FK attribute pointed to the table A
PK column in EOModeler. This strangely has not caused any problems up
until this point in testing. So I guess the lesson is if you copy and
paste attributes in EOModeler be sure to change the column name.
As far as the comment Jonathan made "Additionally, it's a bit odd to use
BigDecimal for a PK/FK." The value class of my PK/FK is Number the
Value Type is B the external type is longlong. This is how EOModeler
sets them when I reverse engineer the schema from the database. Since
it is an officially supported database (OpenBase) I assume EOModeler is
picking the correct settings.
--Albert
-----Original Message-----
From: Chuck Hill [mailto:email@hidden]
Sent: Monday, October 20, 2003 5:40 PM
To: Albert Jagnow; email@hidden
Subject: Re: Cascade delete with optional to-one relationship
That means you have a referential integrity problem in your database.
You
have an A object related to a B object (with a PK of 2) that does not
exist. Fix your bad data and this will go away.
Chuck
This e-mail (including any attachments) is covered by the Electronic
Communications Privacy Act, 18 USC. 2510-2521. It is confidential and
may be legally privileged. If you are not the intended recipient, you
are hereby notified that any retention, dissemination, distribution, or
copying of this communication is strictly prohibited. Please reply to
the sender that you have received the message in error, and then delete
it. Thank you.
_______________________________________________
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.