bag with sql-delete

krasig · **Joined:** Fri Feb 10, 2006 8:33 am **Posts:** 32

Hi all

I have a simple map with collection in form:

Code:

.
.
<bag name="biblFiles" table="BIBL_FILES" inverse="false" cascade="all-delete-orphan" lazy="false" >
    <key column="id_object"  not-null="true" update="false" />
    <one-to-many class="com.indexbg.sp.library.db.BiblFiles"/>
     
</bag>
.
. 

every time when deleting parent object , children objects deleted 1 by 1.
So i decided to optimize this end trying

Code:

.
.
<bag name="biblFiles" table="BIBL_FILES" inverse="false" cascade="all-delete-orphan" lazy="false" >
    <key column="id_object"  not-null="true" update="false" />
    <one-to-many class="com.indexbg.sp.library.db.BiblFiles"/>
  [b]<sql-delete>DELETE FROM bibl_files where id_object=?</sql-delete> [/b]
</bag>
.
. 

but this DELETE statement is never executed.
Where my mistake?

Sorry for my poor English.

gonzao_diaz · **Joined:** Mon Nov 26, 2007 2:29 pm **Posts:** 443

Try your first mapping, with cascade set to "save-update" instead of "all".

krasig · **Joined:** Fri Feb 10, 2006 8:33 am **Posts:** 32

if cascade=save-update" then hibernate first is trying to delete parrent object, and i will have exception - integrity constraint

bertrand · **Posted:** Mon Sep 15, 2008 5:20 am

the correct syntax seems to be:

Code:

all,delete-orphan

krasig · **Joined:** Fri Feb 10, 2006 8:33 am **Posts:** 32

nno. this is not decision.

gonzao_diaz · **Joined:** Mon Nov 26, 2007 2:29 pm **Posts:** 443

I just answered a similar post, on how to reduce the number of queries on a cascade delete.

http://forum.hibernate.org/viewtopic.ph ... 70#2395370

Basically, you cannot do it unless the database itself also implements CASCADE DELETE.

krasig · **Joined:** Fri Feb 10, 2006 8:33 am **Posts:** 32

Yes, i know this. but this is not my question.
Who will explain how to work with <sql-delete> , <sql-delete-all>?
Can't find working example.