Hi!
I've got several problems trying to insert a parent /child relation.

The mapped files :

<class name="beans.Agents" table="agents">

... (properties and id )

<set name="usuaris" lazy="false" inverse="true" cascade="delete">
<key>
<column name="idAgent" />
</key>
<one-to-many class="beans.Usuaris"/>
</set>
</class>


<class name="beans.Usuaris" table="usuaris">

<composite-id name="usuarisKey" class="pw.net.beans.Usuaris$UsuarisKey">
<key-property name="idUsuari" column="idUsuari" type="java.lang.String" length="12"/>
<key-property name="idAgent" column="idAgent" type="java.lang.Integer" length="10"/>
</composite-id>

<many-to-one name="agent" class="beans.Agents" update="false" insert="false" cascade="save-update">
<column name="idAgent"/>
</many-to-one>
...
</class>

I fill the object Agents (the parent one) with all fields, including the Child field, but in Database i can only see one row inserted, the parent one.
What should i do?
I tried to change the attribute : insert="false", in the many to one mapping, but it shows me the following error:

Repeated column in mapping for class beans.Usuaris should be mapped with insert="false" update="false": idAgent


Thanks for advanced, and sorry for my unknowledge.

You have to set the cascade attribute to all or save-update. Otherwise the children will not be saved.

Reto

Sorry but, i tried to put cascade=all in my mapping, like this:

<set name="usuaris" lazy="false" inverse="true" cascade="save-update">
<key>
<column name="idAgent" />
</key>
<one-to-many class="beans.Usuaris" />
</set>

and i found the following exception :

PILA EXCECUCIÓ[
net.sf.hibernate.HibernateException: Batch update row count wrong: 0
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:65)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:127)
....

Can anybody help me please?

Thans for advanced.

Hi, salino,

I am doing the similar test like you. But i am stupid enough stuck here.

I even could not get the data insert into database(parent and child).

Could you post your java codes after session open and before session close? i want to see how to initialize primary key class and set , thanks!

Hi,

Use [unsaved-value="any"] in mapping file for beans.Usuaris class
it worked for me.see if it fits ur requirment.

Samvi