Hi all,

I 'm trying the mapping for One-to-Many( One Customer has many Address).
with the foreign key relationship in the Address Table

I have collection of Address in Customer.
then i 'm inserting the Customer using sessionVar.save(customer)
So I 'm getting the following query and Data was inserted fine.

But my issue here is, on the line numbers of the query [2]and [3], address data been inserted with the foreign key [CUSID],even then it is firing two more quries to update CUSID.

I feel it is unnecessary. With this posting i have given my mapping files for both address and Customer. Plz guide me if anything i need to do to avoid this.


Hibernate version: 3.0

Mapping documents:
---------------------
Mapping file for Customer

<hibernate-mapping package="mapping/one2many/set">
<class name="Customer" table="CUSTOMER" lazy="true" >
<id name="cusId" type="long" column="CID">
<generator class="increment"/>
</id>
<property name="name" column="NAME" access="field" />
<set name="addresses" table="ADDRESS" cascade="all">
<key column="CUSID"/>
<one-to-many class="Address"/>
</set>
</class>
</hibernate-mapping>

-----------------------------
Mapping file for

<hibernate-mapping package="mapping/one2many/set">
<class name="Address" table="ADDRESS" proxy="Address" lazy="true" >
<id name="addId" type="long" column="ADDID">
<generator class="increment"/>
</id>
<property name="address" column="ADDRESS"/>
<many-to-one name="customer" column="CUSID" cascade="all" class="Customer" />
</class>
</hibernate-mapping>

Code between sessionFactory.openSession() and session.close():

txn = ses.beginTransaction();
Customer person = new Customer();
person.setName("Abc");

Address info = new Address();
info.setAddress("Address");

Address info2 = new Address();
info2.setAddress("Address2");

person.setItem(info);
person.setItem(info2);

ses.save(person);
txn.commit();

Full stack trace of any exception that occurs:

Name and version of the database you are using: HQL

The generated SQL (show_sql=true):


[1]insert into CUSTOMER (NAME, CID) values ('ABC', 4)
[2]insert into ADDRESS (ADDRESS, CUSID, ADDID) values ('Address', 4, 7)
[3]insert into ADDRESS (ADDRESS, CUSID, ADDID) values ('Address2',4, 8)
[4]update ADDRESS set CUSID=4, POSITION=0 where ADDID=7
[5]update ADDRESS set CUSID=4, POSITION=1 where ADDID=8

Debug level Hibernate log excerpt:

Looks like you need to add inverse="true" to your <set name="addresses"...>, and remove the cascade attribute from the <many-to-one> on the other side.

Add to addresses set mapping inverse="true" and do not forget assign customer object that owns that address to customer property on address. Then it will not be updating addresses.

Hi Nathan,Basilio
now i 'm getting the expected result. Thanks.
If i get the logic behind it, it will be more useful for me.

Regards,
Selvaraj.V

This chapter in the docs explains it all: http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#example-parentchild

In general inverse="true" means that other side will be responsible to create relationship (assign foreign key value). Other words before address will be inserted FK will be assigned.

Hi nathan and Basilio,

Now i understood the concept of inverse="true" thanks.

Regards,
Selva varadhan