Problem with CascadeType.DELETE_ORPHAN in EJB 3 beta 1

[ceracm]

My class has a undirectional one-to-many relationship.
I want the children to be automatically deleted when removed from the collection and so I'm using DELETE_ORPHAN:

@Entity(access = AccessType.FIELD)
public class PendingOrder implements Serializable {
...
 @OneToMany(cascade = { CascadeType.ALL })
 @OrderBy("index")
 @JoinColumn(name = "PENDING_ORDER_ID")
 @org.hibernate.annotations.Cascade(org.hibernate.annotations.CascadeType.DELETE_ORPHAN)
 private List<PendingOrderLineItem> lineItems = new ArrayList<PendingOrderLineItem>();

..

This doesn't seem to be working.
Rather than deleting the children EJB3/Hibernate is setting the FK column to null.

I also noticed this in the log:

2005-07-14 13:42:49,921 DEBUG [org.hibernate.cfg.annotations.CollectionBinder] Binding a OneToMany: net.chrisrichardson.foodToGo.ejb3.domain.PendingOrder.lineItems through a foreign key
2005-07-14 13:42:49,921 DEBUG [org.hibernate.cfg.annotations.CollectionBinder] Collection role: net.chrisrichardson.foodToGo.ejb3.domain.PendingOrder.lineItems
2005-07-14 13:42:49,921 DEBUG [org.hibernate.cfg.annotations.PropertyBinder] Building property lineItems
2005-07-14 13:42:49,921 DEBUG [org.hibernate.cfg.annotations.PropertyBinder] Cascading lineItems with all,delete-orphan

2005-07-14 13:42:52,312 DEBUG [org.hibernate.persister.collection.AbstractCollectionPersister] Static SQL for collection: net.chrisrichardson.foodToGo.ejb3.domain.PendingOrder.lineItems
2005-07-14 13:42:52,312 DEBUG [org.hibernate.persister.collection.AbstractCollectionPersister] Row insert: update FTGO_PENDING_ORDER_LINE_ITEM set PENDING_ORDER_ID=? where id=?
2005-07-14 13:42:52,312 DEBUG [org.hibernate.persister.collection.AbstractCollectionPersister] Row delete: update FTGO_PENDING_ORDER_LINE_ITEM set PENDING_ORDER_ID=null where PENDING_ORDER_ID=? and id=?
2005-07-14 13:42:52,312 DEBUG [org.hibernate.persister.collection.AbstractCollectionPersister] One-shot delete: update FTGO_PENDING_ORDER_LINE_ITEM set PENDING_ORDER_ID=null where PENDING_ORDER_ID=?

Any suggestions?

Thanks.

Chris

[epbernard]

Show me the code manipulating your object

[ceracm]

The code does the following:
1. Load the PendingOrder - EntityManager.find()
2. Invokes an update() method on the PendingOrder
3. PendingOrder.update() does lineItem.clear() (removing lineItems individually behaves the same)
4. PendingOrder.update() creates new line items and adds them to the collection

FYI The Hibernate version of the code works fine.

Chris

[epbernard]

WDYM by the Hibernate version of the code?
You mean the code using the Hibernate APIs and Hibernate Annotations?

[ceracm]

Almost.
The original code that I am migrating to EJB 3 used the Hibernate APIs and the Hibernate XML mapping.

[ceracm]

Any idea why this is not working?

[epbernard]

Provide a runnable test case to Hibernate JIRa and I'll look at it.

[coolme]

I have the same problem.

[epbernard]

same answer

[ceracm]

"epbernard" wrote:
Provide a runnable test case to Hibernate JIRa and I'll look at it.

Done. See http://opensource2.atlassian.com/projects/hibernate/browse/EJB-54

[epbernard]

I was faster :-)
http://opensource.atlassian.com/projects/hibernate/browse/EJB-53