Creating a class from multiple tables

gjz22 · **Joined:** Wed Dec 03, 2003 2:43 pm **Posts:** 22

Forgive if this has been answered many timed before. I have checked the faq but couldn't find anything.

If I want to create a class that uses many tables for its properties can I do this or do I have to subclass?

For example, if I have a table 'table1' with properties:

ID
NAME
ADDRESS
ZIPCODE

and another table 'table2' with properties:
TABLE1_ID
FAVORITE_COLOR
FAVORITE_ANIMAL
FAVORITE_FOOD

Is it possible to create a class 'Person' with properties name, address, favoriteColor, favoriteAnimal, and favoriteFood, or do I have to create a class BasePerson with just name, address and zipcode and then ExtendedPerson which extends BasePerson to get all the properties?

Thanks for the info!

emmanuel · **Posted:** Wed Dec 03, 2003 2:53 pm

You must subclass, what you want is expected in hibernate 2.2.

You can also do a one-to-one mapping (and allow lazy initialization).

dimas · **Posted:** Wed Dec 03, 2003 2:53 pm

imho, you have to create Base & Extended person. Working with single object spread among several tables is TODO for Hibernate 2.2

gjz22 · **Joined:** Wed Dec 03, 2003 2:43 pm **Posts:** 22

Thanks for the info!

gjz22 · **Joined:** Wed Dec 03, 2003 2:43 pm **Posts:** 22

Is it possible to have a subclass of a subclass?

emmanuel · **Posted:** Wed Dec 03, 2003 7:35 pm

gjz22 wrote:

Is it possible to have a subclass of a subclass?

Yes, you can have subclasses of subclasses or joined-subclassed of joined-subclasses