Hey All:

Hibernate 3.2.2
DB2 V9.1


I have a class (Address) which I want to map it to more than one class, the problem is that these tables are not directly related to each other
for example

Address has a one-to-one with departement
Address has a one-to-one with street
departement has a many-to-one with Governerate
Governerate has a many-to-one with state

table Address is linked to Governerate through departement-> Governerate
, and linked to state throuh departement->Geovernarate->state

I want my Address Class to look like this
class Address {

private long ID;
Private string departement;
Private string street;
Private string Governerate;
Private string state;


}


I can do the first two links(departement,street) by doing a join, but the rest is what i can't figure it out

I know that the tables relationships seems odd , but that's something i don't have control over unfortunatly
please anybody tell me how to solve this problem, or if there's a better way to do it

Thanks
Harraz

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

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

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html