Delete entity with relations

knoll · **Joined:** Fri Jun 25, 2004 11:47 am **Posts:** 34

Hi,

I've the following entities relation, a Person has many Addresses:

Code:

public class Person{
  private String name;
  private Set<Address> addresses;
  ...

Code:

public class Address{
  private Person person;
  private String street;
  private String city;
  ...

Now, I would like to do a bulk delete of Person entities having name containing 'titi'. I would writte a query similar to this one:

Code:

  ...
  StringBuffer hql = new StringBuffer("delete from Person person where person.name like '%?%' ");

When the query will be executed, there will be parent FK violation has there are still addresses.

Question:
Do you know how (or if possible) I can remove in one statement (at least from hql) the person and related relations?

sjhyam · **Joined:** Fri Jun 01, 2007 12:41 pm **Posts:** 121

Did you try cascade option.

http://www.hibernate.org/hib_docs/reference/en/html/objectstate.html#objectstate-saveorupdate

martin_j · **Joined:** Sun Jul 29, 2007 9:10 am **Posts:** 8

sjhyam's right. You need to map the collection with cascade="delete" if you want associated addresses deleted as well. If you're not willing to use such an option you will have to manually delete the addresses first.

Cheers
Martin

knoll · **Joined:** Fri Jun 25, 2004 11:47 am **Posts:** 34

Hi,

Yeap, I've tried with this option which just run fine, when deleting entities by entities.
But what I want to achieve here is to do a bulk delete of entities and I'm just wondering if other association would be also deleted (if it's a behaviour I can except from Hibernate).

One way I could fix this is apparently by using 'ON DELETE CASCADE' on my table definition. But wanted to check with other users if my thought above is correct or wrong.

Rgds,

schauder · **Joined:** Thu Jul 05, 2007 9:38 am **Posts:** 287

Of course you could explicitly delete all the adresses referencing such persons by a seperate statement

mdiaz · **Joined:** Fri Feb 22, 2008 12:45 pm **Posts:** 5

There is a JIRA Issue opened since July 2006 regarding this problem