How do you create joins between two or more tables in hibern

suzie · **Joined:** Fri Nov 03, 2006 4:57 pm **Posts:** 60

How do you create joins between two or more tables in hibernate? is that possible...

batmat · **Posted:** Sun Dec 10, 2006 11:58 am

Obviously it's possible.

For example, in the reference documentation :
http://www.hibernate.org/hib_docs/v3/re ... e-fetching

Code:

User user = (User) session.createCriteria(User.class)
                .setFetchMode("permissions", FetchMode.JOIN)
                .add( Restrictions.idEq(userId) )
                .uniqueResult();

This code is using the Criteria API. It will create a query that will join the User table and the Permission one.