deleting child entity

yigit.darcin · **Joined:** Wed Jan 14, 2009 7:25 pm **Posts:** 5

Hello All,

I am having a problem when I set null to a manytoone relation and persist the object, the child entity is not deleted.

For example with the following code:

Code:

@Entity
public class Ad{

   @ManyToOne(cascade=CascadeType.ALL)
   private Action action;

... setters getters other things...
}

so this Ad class will have a property called action. My Action class and its child classes are as follows:

Code:

@Entity
@Inheritance(strategy = InheritanceType.SINGLE_TABLE)

public abstract class Action{
...
}

@Entity
public class AudioAction extends Action {
}



@Entity
public class VideoAction extends Action {
}

so think of following scenario: I have an Ad object. it has a VideoAction object. They all persisted.

When user tries to update the Ad object, and sets a new AudioAction object for example, the DB is updated with the correct data. but the old, orphan VideoAction still remains in the DB as there is no reference to it.

How can I make sure old VideoAction is deleted when I set another Action object, or when I set null to the Ad's action property?

Thanks,

Yigit

yigit.darcin · **Joined:** Wed Jan 14, 2009 7:25 pm **Posts:** 5

anyone?

nordborg · **Posted:** Wed Feb 10, 2010 3:44 am

Quoted from the Hibernate documentation (http://docs.jboss.org/hibernate/stable/ ... -manytoone):

Quote:

Note that single valued, many-to-one and one-to-one, associations do not support orphan delete.

In other words, you'll have to call session.delete() in your own code.

gpeel · **Posted:** Fri Oct 01, 2010 9:06 am

Ok I check with version 3.5.5 and it does NOT work.
But Why does JIRA says this feature has been corrected ?
http://opensource.atlassian.com/project ... e/HHH-4726

I tried with the following XML mapping :

<hibernate-mapping>
<class name="business.hb.Address" schema="public" table="address">
<id name="id" type="long">
<column name="id" />
<generator class="foreign">
<param name="property">person</param>
</generator>

</id>
<version generated="never" name="version" type="int">
<column name="version" not-null="true" />
</version>
<property generated="never" lazy="false" name="description"
type="string">
<column length="50" name="description" />
</property>
<one-to-one name="person" class="business.hb.Person" constrained="true" />
</class>
</hibernate-mapping

<hibernate-mapping>
<class name="business.hb.Person" schema="public" table="person">
<id name="id" type="long">
<column name="id" />
<generator class="org.hibernate.id.enhanced.TableGenerator">
<param name="table_name">ID_GENERATOR</param>
<param name="value_column_name">GEN_VALUE</param>
<param name="segment_column_name">GEN_ID</param>
<param name="segment_value">PERSON_ID</param>
<param name="increment_size">50</param>
<param name="optimizer">pooled</param>
<param name="max_lo">100</param>
</generator>
</id>
<version generated="never" name="version" type="int">
<column name="version" not-null="true" />
</version>
<property generated="never" lazy="false" name="name" type="string">
<column length="50" name="name" />
</property>
<one-to-one name="address" class="business.hb.Address" cascade="all,delete-orphan" constrained="true"/>
</class>
</hibernate-mapping