Hibernate version:
2.1.6
Mapping documents:
Parent:
<bag
name="hits"
lazy="false"
inverse="true"
cascade="all"
>
<key
column="Identification_ID"
>
</key>

<one-to-many
class="com.mds.pepland.persistence.IdentificationHit"
/>
</bag>

Child:
<many-to-one
name="identification"
class="com.mds.pepland.persistence.IdentificationImpl"
cascade="none"
outer-join="auto"
update="true"
insert="true"
access="property"
column="Identification_ID"
not-null="true"
/>

Name and version of the database you are using:
MySQL 4

I have a chain of parent-child relationships several levels deep.. they are all mapped as shown above..

when i delete for instance an Identification object, Hibernate selects everything in the chain below the object I'm deleting and then deletes each record one by one using "delete from xx where primary_key=yy"..
Is there a way to get Hibernate to use the foreign keys in the delete statements instead? (for obvious performance reasons)..

as a side note I can say that none of the objects that must be deleted has a second level cache...

parent.setChildrenCollection(null);
tx.commit();

Naw, that doesn't help for associations.

Efficient cascade delete is in HB3.

Right, for future readers: this trick only works for collections of value typed objects.

Do you mean oneshotdelete?
http://www.hibernate.org/hib_docs/refer ... shotdelete

I have tried,but result is a single update statement:
java code:
invoice.getInvoiceDetails().clear();
session.delete(invoice);
hibernate trace:
Hibernate: update SCOTT.INVOICE_DETAIL set INVOICE_ID=null where INVOICE_ID=?
Hibernate: delete from SCOTT.INVOICE where ID=?

I want "delete SCOTT.INVOICE_DETAIL where INVOICE_ID=?"

invoice.hbm.xml
<set name="invoiceDetails" inverse="false" cascade="delete">
<key column="INVOICE_ID"/>
<one-to-many class="entity.InvoiceDetail"/>
</set>

invoicedetail.hbm.xml
<many-to-one name="invoice" class="entity.Invoice">
<column name="INVOICE_ID" length="9" precision="0" not-null="false"/>
</many-to-one>

any idea?

I found hibernate can do a smart cascade delete with idbag

<idbag name="invoiceDetails" table="INVOICE_DETAIL" cascade="delete" order-by="ID asc">
<collection-id column="ID" type="int" >
<generator class="native"/>
</collection-id>
<key column="INVOICE_ID"/>
<composite-element class="entity.InvoiceDetail">
<parent name="invoice"/>
...
</property>
</composite-element>
</idbag>

Hibernate: delete from INVOICE_DETAIL where INVOICE_ID=?
Hibernate: delete from SCOTT.INVOICE where ID=?