JBoss-EJB3.0-Cascade delete doesn't work!

[jbosschecker]

I have two CMP entities, which are mapped to a mysql schema:

1.Entity:

@Table
Order.java

2. Entity:

@Table
OrderItem.java

The Order Entity has a field with a @OneToMany Realtion.

I am trying to use the jboss - ejb3.0- cascade delete function, to delete the orderItems, when an order object is deleted, but it dosent work!

I found an older posting, in which one said, that not every database supports "cascade delete".
Was he right?

[starksm64]

Moved to the ejb3 forum.

[jbosschecker]

APPENDIX:

It works fine with

@OneToMany (cascade = CascadeType.REMOVE, mappedBy="order")

but not with


@OneToMany (cascade = CascadeType.ALL, mappedBy="order")

Even though, CascadeType.ALL contains REMOVE in itself!

[jbosschecker]

Sorry! I did a mistake! It does not work neither with
CascadeType.REMOVE nor with CascadeType.ALL!!

[jbosschecker]

And once again, I have found the reason myself!!
It has been a bug in the last version of JBOSS AS.

Sea the release notes of jboss 4.0.3 :

"[ JBAS-51 ] bug in cascade-delete with relationships in Jboss CMP "

[epbernard]

EJB3 entities does not use the CMP engine, so the bug cannot be related

[jbosschecker]

Hi Emanuel,
would you - please - explain it a little bit more precise.
I do not understand that.

I thought, that EJB 3.0 entities do even use the CMP engine.

I have installed the new jboss release (4.0.3 RC2) but the problem is still there!


please help me to understand that.

[tonylai]

Me too, with the same problem on SQL Server for the formal release version(4.0.3). Do you try to delete an object from the list of orderDetails and save the order? Also, the deleted object of oderDetails was not deleted from the database.

[jbosschecker]

Yes Its the same to me. I have to delete the orderdetails by hand!

Maybe its an issue of mysql?

[epbernard]

"jbossChecker" wrote:
Hi Emanuel,
would you - please - explain it a little bit more precise.
I do not understand that.

I thought, that EJB 3.0 entities do even use the CMP engine.

I have installed the new jboss release (4.0.3 RC2) but the problem is still there!


please help me to understand that.

EJB3 use Hibernate
EJB2 use the CMP engine
2 different base code

[epbernard]

"tonylai" wrote:
Me too, with the same problem on SQL Server for the formal release version(4.0.3). Do you try to delete an object from the list of orderDetails and save the order? Also, the deleted object of oderDetails was not deleted from the database.

removing an object from a collection does not suppress this object unless you set DELETE_ORPHAN check the doc for more info