Hi,
I am facing a problem when i try to save one object data into two tables.I am unable to understand how to map these tables in mapping file.
For example:
I have a class Person ,that contain information about Name &Address.
I want to save Name in Name_Table & Address in Address_Table.
How can i do it?


Thanks
SPT

I think this is not a mapping problem, but it's a domain problem.

Why you should want to save a Person information in two separate tables instead than in one single table (PERSON_TABLE(person_id, name, address).
Anyway a solution could be to create your own Name/Address class (with just one field, eg: name.content or address.content) and map those ones.
So when you try to store/retrieve a Person object, you also invoke the NameDAO.store operation and store the NAME object in the NAME_TABLE table.


EG:



It's not a so elegant solution, but I can't figure out why You should save info in two separate tables.

Regards

Thanks ciccio17

I think you are right.
But actually I am using Spring and Hibernate Framework .
I want to save data in both table with an object.
I tried to make Address_Table as a sub class of PERSON_TABLE.
In this case what will be the Person.hbm.xml and Address.hbm.xml?

The reason of doing this is that we can make only one command class in one controller.
I am trying it so that I can make a command class and usig it I can access the other table.


Please guide me.

Thanks in advance.

What I am asking is: Are your ADDRESS_TABLE and NAME_TABLE really necessary in your application?

It's enough to save your whole Person Object in the PERSON_TABLE(person_id, person_name, person_address). Then, if you have to retrieve all the names (and/or all the addresses) you can just run a simple query (select person_name from PERSON_TABLE, select person_address from PERSON_TABLE).

Regards

Actually ciccio17 ,
This is not actual tables . These are for example.
I am using large tables in my project thats why i want to use two tables.
Have you any idea to do that.

Thanks