Hi All,

I have gone through one sample at
http://www.vaannila.com/hibernate/hibernate-example/hibernate-mapping-many-to-one-1.html

and tested the code which is working fine.

In above code If I want to save a Student Object I will save Address also in database which means that table Student and Address both will be filled with one more row.

My Scenario:
In my case huge Address table is already there and I just need to save Student Object by selecting Address_id (typically from UI). There should be no adding records of Address table.

Please let me know how to do that using Many to One Relationship.

I know it can be done using without using any Relationship.

Please help.

Thanks and Ragards,
Vikash Anand.

I think you will only need to remove the cascade="all" to the mapping of the property studentAddress in Student.hbm.xml.
Be carefull, before saving a Student you will have to set his address with one yet present in DB.

Bye
Stefano

Thanks for info. Your suggestion worked fine.

I have one more query:
I need to create database where multiple tables are joined with Many to one relationship.

E.g.
A related to B
B related to C
C related to D
D related to E
E related to F
and so on....

If I use many to one relationship will all child relations be loaded if a row for A is loaded? Please refer to your comment:
Be carefull, before saving a Student you will have to set his address with one yet present in DB

Thanks and Regards,
Vikash Anand.

Further to my first question if I need to edit records of A do I need to load all child rows and save it??

No, you don't.
The "cascade" property tells Hibernate what to do when persisting an entity (save or delete related data, ....).
When you load an entity, Hibernate behavior is determined by the "lazy" and "fetch" attributes. So when loading an A entity, Hibernate could fetch the entire DB or apply a lazy approach depending on the mappings. Refer to the documentation available on-line for an exhaustive explanation: http://docs.jboss.org/hibernate/core/3. ... mance.html

Stefano