Help with Hibernate Criteria

[Hanna Habashy]

Three tables:
User - contains user information
application - contains applications information
user2application - a bridge table between user and application. Composed of primary key or user, and primary key of application

Query:
Retreive all users by application ID.

SQL:

   
select * from user u
inner join user2application u2p
on u2p.userid = u.userId
where u2p.applicationId = 1
 

I created this criteria, but not efficient. Produces a select statement for every user.

   
crit = getHbnSession().createCriteria(User2Application.class, "u2a");
      crit.add(Restrictions.eq("u2a.application.applicationId", appId));
      crit = crit.setProjection(Property.forName("user"));
      crit = crit.createCriteria("user", "u");   
 

Is there any other efficient way?

Thanks

[Paul Sturrock]

Try changing the fetch mode.

[Hanna Habashy]

Paul Sturrock wrote:Try changing the fetch mode.

The fetch mode in the .hbm file is set to join

I added this line:

crit = getHbnSession().createCriteria(User2Application.class, "u2a");
crit.add(Restrictions.eq("u2a.application.applicationId", appId));
crit = crit.setProjection(Property.forName("user"));
crit.setFetchMode(FetchMode.JOIN);
crit = crit.createCriteria("user", "u");

But, it didn't do anything different.

Any other ideas?