CMP - Cascade delete with mysql does not work!

[jbosschecker]

Hi!,

I'm working with jboss 4.0.3, mysql 4.1 as Datasource and JBoss-CMP.

I have an order entity bean, that has a @OneToMany relation to an orderDetail entity, and I want the OrderDetails to be deleted, when I delete one order object.

I have annotated the OnToMany relation like this:

@OneToMany(cascade = CascadeType.ALL, mappedBy = "order")
@JoinColumn(name = "orderId")
public List<OrderDetail> getOrderDetails() {
return orderDetails;
}

But when I delete an order object, the orderdetails remain in the DB.


In my persistence.xml file, I set the value of the hibernate.hbm2ddl.auto parameter to 'none',



but I guess my problem is independent from that entry.

Am I doing something wrong?
Has anybody experienced the same problem?

[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.

[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.

[dvohra09]

Is the ON DELETE CASCADE specified in the database table?
Also specify ON DELETE CASCADE in the database table.

[jbosschecker]

"dvohra09" wrote:
Is the ON DELETE CASCADE specified in the database table?
Also specify ON DELETE CASCADE in the database table.

Yes it is. I have specified this also in the innoDB tables. BUt there is no difference.

Someone told me this:

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

But I remember havaing done that already.

[epbernard]

"jbossChecker" wrote:

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

But I remember havaing done that already.

I'm very doubtful