Hi Michele,
One thing to check is whether you have "to dep pk" set up correctly for
DbEntities. It should be checked for these relationships: object1 ->
object1_to_object2 and object2 -> object1_to_object2. AMong other
things, this setting hints Cayenne how to order delete operations to
satisfy constraints.
Andrus
On Sep 16, 2004, at 9:40 AM, Michele Cuozzo wrote:
> Hi everybody,
>
> I've got a problem with objects deletion:
> for example I've got Object1 and Object2 classes binded with a
> many-to-many flattened relationship ( so in the database I've got a
> bind table object1_to_object2 not present in the ObjectEntity list of
> my model);
> I've setted a delete rule that say Cascade on Object1 deletion but
> when I try to remove an instance of Object1 I've got an SQLException
> like the following:
>
> java.sql.SQLException: ERROR: <unnamed> referential integrity
> violation - key in object2 still referenced from object1_to_object2
>
> I'm using PostgreSQL 7.2
>
> Where is the problem?
>
> thanks in advance
>
> Michele
>
This archive was generated by hypermail 2.0.0 : Thu Sep 16 2004 - 11:09:30 EDT