FAQ
DbMerger logic fails to fix invalid complex FKs
-----------------------------------------------

Key: CAY-1099
URL: https://issues.apache.org/cayenne/browse/CAY-1099
Project: Cayenne
Issue Type: Bug
Components: Cayenne Core Library
Affects Versions: 3.0
Environment: 3.0 M4, Derby
Reporter: Scott Anderson
Assignee: Andrus Adamchik


The merger tries to do the following:
ALTER TABLE mail ADD FOREIGN KEY (sentto) REFERENCES account (id)

Which fails with the error:
Foreign Key 'SQL080826163049030' is invalid because 'The table cannot be defined as a dependent of table APP.ACCOUNT because of delete rule restrictions. (The relationship causes the table to be delete-connected to the indicated table through multiple relationships and the delete rule of the existing relationship is SET NULL.). '.

mail has a 'sentto' and 'sentfrom' field, in the style of REFERENCES account (id) ON DELETE SET NULL

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdev @
categoriescayenne
postedAug 26, '08 at 10:29p
activeAug 26, '08 at 10:29p
posts1
users1
websitecayenne.apache.org

1 user in discussion

Anonymous: 1 post

People

Translate

site design / logo © 2022 Grokbase