Hi all,

I have two enties having a many to many relation with each other. Let's call them A and B. The relation is defined via a join table A_B, defined in B. Now I want to remove all B's from the database with a bulk update with a named Query

DELETE FROM B

But the database tells me that this is not possible because of foreign constraints. These apply to the relation table, of course. My question is: is there a way to reset the relation / clear the relation table from within EJB?

And: I googled for the EJB specification, but I have not yet found it. Any hints?

Thanks in advance,
Jochen