how to use hibernate with three more tables

Narasimha · **Posted:** Sat Oct 04, 2008 5:29 am

how to use hibernate criteria for using three more tables at a time

gonzao_diaz · **Joined:** Mon Nov 26, 2007 2:29 pm **Posts:** 443

There is no limit in the number of tables that can be linked on a query, if this is correctly reflected in the mapping files.
You refer to additional tables using either an alias or a subcriteria.

kibbled_bits · **Posted:** Tue Oct 07, 2008 5:34 pm

I needed to query for results based on data several levels deep in the relationship hierarchy. This is the code I used:

Code:

session.CreateCriteria(typeof(AppSection))
                               .CreateCriteria("AppRoleSectionAccess")
                               .CreateCriteria("Role")
                               .CreateCriteria("RoleMembers")
                               .CreateCriteria("User")
                               .Add(Expression.Eq("Id", user.Id))
                               .SetResultTransformer(new DistinctRootEntityResultTransformer())
                               .List<AppSection>())

Just change the result transformer to whatever suits your needs.

Narasimha · **Posted:** Wed Oct 08, 2008 2:26 am

Hi to All
thanks for previous replies to kibbled_bits and gonzao_diaz
now my Query is

how can i use this jdbc Query from hibernate Criteria please give me reply. thanks in advance

query = "select * from glt_connections con,GLT_SYSTEM_ORG_ASSOIC ass where con.connection_id = ass.SYSTEM_ID and ass.ORG_ID=?";

Thanks,
Narasimha.