posted 15 years ago
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
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