4 Replies Latest reply on Jul 4, 2006 10:14 AM by horst21

ManyToMany: delete causes a violation of foreign key constra

horst21 May 18, 2006 3:09 AM

Hello,
I got a Problem deleting persistent EJB3 entity objects:

I got a class PointOfPayment that has a ManyToMany relation to the class Account.
When I try to delete a persistent PointOfPayment object that has an entry in the relation-collection to account, I got an exception:

org.apache.derby.client.am.SqlException: DELETE on table 'POINT_OF_PAYMENT' caused a violation of foreign key constraint 'FK712B399B71820D81' for key (98304). The statement has been rolled back.

Query q = em.createQuery("delete PointOfPayment");
q.executeUpdate();

I guess that the problem is that entries in the join-table of the ManyToMany relation are not deleted automatically. Do I have to take care of the entries in the relationtable myself? Do I have to remove the account object from the relation before deleting the PointOfPayment?

The database I am using is: apache derby 10.1.2.1.
The JBoss ejb3 Version is: jboss-EJB-3.0_RC6

thanks for your help, cheers.

1. Re: ManyToMany: delete causes a violation of foreign key con

horst21 May 18, 2006 3:37 AM (in response to horst21)

as workaround I tried to use native sql to delete the contents of the join-table. But apparently native sql cannot be used for delete operations, can it?
Actions
2. Re: ManyToMany: delete causes a violation of foreign key con

maxandersen May 18, 2006 3:52 AM (in response to horst21)

in hibernate 3.2 it can.
Actions
3. Re: ManyToMany: delete causes a violation of foreign key con

horst21 May 24, 2006 6:53 AM (in response to horst21)
It seems, that this problem occurs with every relation that is based on a join-table. what do I do wrong?
I do not think that changing the cascade-type of the relation will solve the problem since that does not influence the join-table, does it?

my mapping looks like this:
public class PrivilegeProfile implements Serializable { .... @ManyToMany @JoinColumn(name = "privilige_profile_id") private Set<Privilege> privileges = new HashSet<Privilege>(); ...

any clues?
Actions
4. Re: ManyToMany: delete causes a violation of foreign key con

horst21 Jul 4, 2006 10:14 AM (in response to horst21)

doesn't anybody else have this problem?
I still can not delete Entities from ManyToMany relations. what do I do wrong? any clues?
Actions

Go to original post