On Oct 26, 2009, at 4:39 AM, Freddie Tilley wrote:
I have a Tree object linking to itself via a parent id and when I set
the child relationship to cascade.
But when I delete the parent object (with children), I get the
following error:
com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression
failed: : Next exception:SQL State:23000 -- error code: 547 -- msg:
The DELETE statement conflicted with the SAME TABLE REFERENCE
constraint "Tree_parent_FK". The conflict occurred in database
"TreeDatabase", table "dbo.Tree", column 'parentID'.
It looks like the cascade isn't working.
The cascade is working but the ordering is wrong. SQL Server can't
handle deferred constraints. The easiest solution is to drop the FK
constraint. The other solution is to order the delete operations and
that is NOT easily done.
Chuck
--
Chuck Hill Senior Consultant / VP Development
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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
