Hi All,
I have Parent, child relationsip and I load only child with following way and issue delete child. I am getting update child SQL - Why

Here is the code

session = HibernateSessionFactory.currentSession();
tx = session.beginTransaction();
log = LogFactory.getLog("selectCaseClm()");
Child cc = (Child)session.get(Child.class, childid);

log.info("*** Got Child"+ cc.toString()+ " ***");

session.delete(cc);

session.flush();
tx.commit();
session.close();


update CHILD set parentkey=? where childkey=?

and get error
net.sf.hibernate.util.JDBCExceptionReporter SQL Error: 1407, SQLState: 72000


Any help?

Thanks
Ramesh

Can you post your mappings?

Parent ---------------------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="efi.edcs.dto.Fldr" select-before-update="true" table="FLDR" dynamic-update="true">
<id name="id" column="FLDR_NUM" type="efi.edcs.persistence.StringType"
unsaved-value="-1" >
<generator class="assigned" />
</id>
-- Set the coumns

-- Child Tables
<set name="cases" cascade="all" lazy="true" inverse="true">
<key column="FLDR_NUM" />
<one-to-many class="efi.edcs.dto.Case" />
<set name="caseclms" cascade="all-delete-orphan" lazy="true" inverse="true">
<key column="FLDR_NUM" />
<one-to-many class="efi.edcs.dto.Caseclm" />
</set>
</class>
</hibernate-mapping>

CHILD ---------------------------------------------------------------------------------------------

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="efi.edcs.dto.Case" select-before-update="true" table="CASE" dynamic-update="true">
<id name="id" column="CASE_NUM" type="efi.edcs.persistence.StringType" unsaved-value="-1" >
<generator class="assigned" />
</id>
-- Set attributes

-- Parent tables
<many-to-one name="fldr" column="FLDR_NUM" class="efi.edcs.dto.Fldr" cascade="all"/>

-- Child Tables
<set name="caseclms" cascade="all-delete-orphan" lazy="true" inverse="true">
<key column="CASE_NUM" />
<one-to-many class="efi.edcs.dto.Caseclm" />
</set>
</class>
</hibernate-mapping>



SUB CHILD--------------------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="efi.edcs.dto.Caseclm" dynamic-update="true" select-before-update="true" table="CASECLM">
<id name="id" column="CASE_CLM_SEQ_NUM" type="string" unsaved-value="-1" >
<generator class="assigned" />
</id>
-- Attributes fot the columns
-- Parent table.
<many-to-one name="edcsCase" column="CASE_NUM" class="efi.edcs.dto.Case" cascade="all" />
<many-to-one name="fldr" column="FLDR_NUM" class="efi.edcs.dto.Fldr" cascade="all" />

-- Child table for this Caseclm table.
<set name="clacthiss" cascade="all-delete-orphan" lazy="true" inverse="true">
<key column="CASE_CLM_SEQ_NUM" />
<one-to-many class="efi.edcs.dto.Clacthis" />
</set>

</class>
</hibernate-mapping>
---------------------------------------------------------------------------------------------


I issues Session.delete( Caseclm); it gave update statment for Caseclm

I really appreciate you kind help

Thanks
Ramesh

eagle79 any idea ?

I apologize rbarun, I've been so wrapped up with a looming deadline at work, I haven't had a chance to look at this in depth. I briefly looked over it last night, and started to mention the cascades on the many-to-one properties of Caseclm, but I don't think that's the problem. You might try removing them temporarily anyway, in case they're creating some sort of strange looping update.

Of course, anyone else out there's welcome to take a look at this and try to answer it.

Hibernate executes update because link between parent and child must be removed.

If U remove foreign key constraint from Oracle table U can see second query deleting child. All U need is to change order of queries.

Try inverse = false. This tag determine order of SQL queries. In other words this tag determine side which will be responsible for link between parent and child.