Hello.

When I declare a simple one-to-many relationship, with unidirectional relation, each child insertion performing 2 SQL statements:

1) Insert the child record with all the fields except the foreign key columns.
2) Update the foreign key columns in the child record.

How can I avoid the second SQL statement ?

Thanks,
Yifat

<class name="Parent">
<id name="id" type="string" column="PARENT_ID">
<generator class="uuid" />
</id>
<property name="name" type="string" length="20" />
<set name="children" cascade="all">
<key column="PARENT_ID" />
<one-to-many class="Child" />
</set>
</class>

<class name="Child">
<id name="id" type="string" column="CHILD_ID">
<generator class="uuid" />
</id>
<property name="name" type="string" length="20" />
</class>

From the log file:

Hibernate: insert into YIFAT.Parent (name, PARENT_ID) values (?, ?)
Hibernate: insert into YIFAT.Child (name, CHILD_ID) values (?, ?)
Hibernate: update YIFAT.Child set PARENT_ID=? where CHILD_ID=?

Hi

set inverse="true" in set element



Amila

(Don't forget to rate if helps)

Thank you for your answer.

Changing to inverse=true prevent the second update but the child records left without a value in the foreign key column and they are not connected to the parent record.

yifat

Hi

I can't understand situation

can you send sql

Amila

Hibernate: insert into YIFAT.Parent (name, PARENT_ID) values (?, ?)
Hibernate: insert into YIFAT.Child (name, CHILD_ID) values (?, ?)

As you can see, the PARENT_ID column is not handled in the Child record insertion and the child left orphan.