Hibernate: query returning data from multiple tables

[Sunit Naik]

I have very recently started working with hibernate and things were moving fine when the queries were getting columns from a single Table.
I have a hibernare query which returns data from multiple tables.

It selects data from three tables based on a join condition

1. tbl_site

2. tbl_ste2sitmgr

3. tbl_sitemanager

tbl_ste2sitmgr is basically a link between site and sitemanager, and contains a fk of site and a fk of sitemanager.

a site can have only one manager but a manager can manage many sites.

lets say this is the hibernate query statement

result = getHibernateTemplate().find(query);

what kind of class should result belong to so that all the retrieved columns be effectively accessed.

I am sorry if this question sounds too lame, but I am a newbie in the hibernate/ORM world. Any help would be deeply appreciated

Thanks

[Ankit Garg]

Your relationship is a one-to-many relationship. One Manager can be associated with many Sites. You can execute a query from any direction. If you retrieve a Site class object, it will have a Manager class object. If you retrieve a Manager class object, then it will have a list of Site class objects...