Hi,

I need some help in Using SQL In Clause with Hibernate. How do I pass mutiple parameters in SQL IN clause using HQL and Criteria class?

Here's the example of the SQL.

select id, name, description from some_table where some_column in (?, ?, ?, ?, ?) order by id;

Best Regards,
Sanjay

In HQL:

String queryString = "select id, name, description from Some s where s.someProperty in (:value1, :value2, :value3, :value4) order by s.id";

List results = session.createQuery(queryString)
.setParameter( "value1", value1, Hibernate.SOME_TYPE )
.setParameter( "value2", value2, Hibernate.SOME_TYPE)
.setParameter( "value3", value3, Hibernate.SOME_TYPE )
.setParameter( "value4", value4, Hibernate.SOME_TYPE)
.list();


In Criteria API:

What about Restrictions.in() ? For example:

Criterion somePropertyIn = Restrictions.in("some_property", new Object[] {"some_value1", "some_value2", "some_value3", "some_value4"});
Criteria crit = session.createCriteria(Some.class);
crit.add(somePropertyIn);
List results = crit.list();

Thanks for that piece of code, worked for me...

parmarsanjay should have posted a rating and should have given u the credit...

Thanks again