Problem with Hibernate Criteria Query

dartmanx · **Joined:** Tue Jul 26, 2005 10:25 am **Posts:** 12

I am trying to return a collection of "User" objects using the following function:

Code:

   public Collection loadDistinctByOrganizationAndRoles(Organization organization, Collection roles) {
        Criteria criteria = getSession().createCriteria(User.class);
        criteria.add(Expression.eq("assignedOrganization", organization));
        criteria.add(Expression.in("roles", roles));
        return criteria.list();

}

My question: is Expression.in() capable of iterating over the roles collection, or will I have to write the iteration myself to keep adding "ors" to the criteria?

Hibernate version is 3.1.3.

Jason

kochcp · **Posted:** Mon Aug 21, 2006 11:37 am

should be able to use the Collection if the values are sensible

CWitherow · **Posted:** Mon Aug 21, 2006 12:46 pm

I've used Expression.in() with over 800 elements in the collection and it worked fine.

Curtis