Hibernate Community • View topic - nested or statements in hibernate criteria

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

nested or statements in hibernate criteria

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

rizqureshi

Post subject: nested or statements in hibernate criteria

Posted: Tue Jun 23, 2009 10:52 pm

Newbie

Joined: Tue Jun 23, 2009 10:44 pm
Posts: 2

Anyone has come across the problem where you need to define multiple or statement in a hibernate criteria. Consider the following code segment:

Code:

Criteria crit = session.createCriteria(Project.class);
           Criteria jobs = crit.createCriteria("jobTypes");
jobs.add(Restrictions.or(Restrictions.eq("id", 1),
                 Restrictions.or(Restrictions.eq("id", 2),
                       Restrictions.or(Restrictions.eq("id", 3), 
                             Restrictions.or(Restrictions.eq("id", 4),Restrictions.eq("id", 5))
           ))));

Now, how would one create such a nested OR cirterion using for/while loop if one has any number of different ids {1,2,3,4,5,6.....}?

Thanks,
Rizwan

Top

rizqureshi

Post subject: Re: nested or statements in hibernate criteria

Posted: Sun Jun 28, 2009 4:30 pm