We have a class Hit with several subclasses (let's say TrademarkHit)




It seems that the on-delete="cascade" does have no effect on the executed queries.

Hibernate still first deletes the 'subclass tables', before deleting the 'main class' table: HIT
(other tables come from other joined-subclasses)

I would think that Hibernate knows that on-delete cascade is on, so it does not need to delete all subclass tables; this is done by the db (Oracle)

The creation of the temporary table is in this case also not needed.

Any thoughts on this?

hi,

I have the same problem. In my test model, I have a root class Payment and a sub-class CreditPayment. I tried to delete all Payment entities:

String hql = "delete events.Payment";
Query query = session.createQuery(hql);
int req = query.executeUpdate();

The generated statements are as follows:

Hibernate:
insert
into
HT_payment
select
payment0_.payment_ID as payment_ID
from
payment payment0_
Hibernate:
delete
from
credit_payment
where
(
payment_ID
) IN (
select
payment_ID
from
HT_payment
)
Hibernate:
delete
from
payment
where
(
payment_ID
) IN (
select
payment_ID
from
HT_payment
)

And I don't know why there is a temporary table HT_payment used and what the two delete statements are good for. In the mapping I used "on-delete=cascade" already, but it doesn't work.

Your help is greatly appreciated. Thank you, Mia