Cascading a OneToOne relation when updating

debae · **Joined:** Wed Jan 16, 2008 2:22 am **Posts:** 4

I made a simple example to explain my problem.

Code:

Public class Person {

@Entity
private Address address;

@OneToOne
@Cascade(CascadeType.ALL)
@JoinColumn(name="ADDRESS_ID")
public Address getAddress() {...}
public void setAddress(Address address);

}

I made a unidirectional OneToOne mapping from Person to Address, and my cascading works when I delete Person, Address is also deleted.

But now when I execute the following code :

Code:

person.setAddress(new Address);
personDao.update(person);

when i look in the database the address_id of the person is correctly changed and references to the new address.
The problem is that the old address is still in the database, no longer in use by anything.

What is the best way to solve this, I don't want any unreferenced address records in my database.
Shoud I create a collection of addresses in my person Entity, and only put one address in it ?

Thanks in advance for any help provided

gonzao_diaz · **Joined:** Mon Nov 26, 2007 2:29 pm **Posts:** 443

would this annotation work?

@Cascade(DELETE_ORPHAN)

debae · **Joined:** Wed Jan 16, 2008 2:22 am **Posts:** 4

DELETE_ORPHAN can only be used for collection, but I also looked on the forum and found this : http://forum.hibernate.org/viewtopic.php?p=2287278 so DELETE_ORPHAN is not going to help me out