In a OneToMany relation, invoking clear() on the collection

[alfonsotames]

I have a OneToMany relation:

@Entity
public class Order implements Serializable {
 private List<Product> orderedProducts;
 @OneToMany(cascade=CascadeType.ALL)
 public List<Product> getOrderedProducts() {
 return products;
 }
}

When i do this:

Order order = manager.find(Order.class, orderid);
order.getOrderedProducts().clear();

The products are not deleted from the database, instead their field orderid is updated to null !!!

Is this normal ?

Thanks,

Alfonso Tamés

[petergoldstein]

This is the behavior dictated by the EJB spec. If you want the orphaned items to be deleted, you need to add an additional Hibernate-specific annotation. Add this:

@org.hibernate.annotations.Cascade({org.hibernate.annotations.CascadeType.ALL, org.hibernate.annotations.CascadeType.DELETE_ORPHAN } )


to the annotations defining the association on the @OneToMany side and you should see the orphaned objects deleted from the database.

--Peter

[alfonsotames]

It works !!!!

Finally it is removing the records instead of setting them to NULL.

I have the EJB3 spec and the docs from JBoss but didn't find this.

Thanks a lot.

Alfonso