cometta
Reputation: 35689
hibernate SELECT..WHERE.. IN (value1, val2...)
when using createCriteria, how to specify SELECT..WHERE.. IN (value1, val2...) ?
Upvotes: 0
Views: 3532
Answers (2)
skaffman
Reputation: 403481
See Restrictions.in:
List cats = sess.createCriteria(Cat.class)
.add( Restrictions.in( "name", new String[] { "Fritz", "Izi", "Pk" } ) )
Upvotes: 8
Related Questions
- Hibernate IN Clause with multiple columns
- Doing an "IN" query with Hibernate
- How use SQL in() in hibernate?
- Using IN clause in a native sql query with Hibernate 3.2.2
- Hibernate Criteria Query for multiple columns with IN clause and a subselect
- Hibernate advanced in clause
- Hibernate where in sub query
- Hibernate Criteria equivalent for IN clause in Subqueries?
- Hibernate(HQL) - how to query "where many in()" many to many
- Java hibernate how to use select ... where id in ()