JPA Criteria builder IN clause query

by

This criteria set-up should do the trick:

CriteriaBuilder cb = entityManager.getCriteriaBuilder();
CriteriaQuery<Employee> q = cb.createQuery(Employee.class);


Root<Employee> root = q.from(Employee.class);
q.select(root);

List<String> parentList = Arrays.asList(new String[]{"John", "Raj"});

Expression<String> parentExpression = root.get(Employee_.Parent);
Predicate parentPredicate = parentExpression.in(parentList);
q.where(parentPredicate);
q.orderBy(cb.asc(root.get(Employee_.Parent));

q.getResultList();

I have used the overloaded CriteriaQuery.where method here which accepts a Predicate.. an in predicate in this case.

More Related Contents:

  1. JPA CascadeType.ALL does not delete orphans
  2. Storing a Map using JPA
  3. Hibernate – @ElementCollection – Strange delete/insert behavior
  4. How do I properly cascade save a one-to-one, bidirectional relationship on primary key in Hibernate 3.6
  5. Hibernate triggering constraint violations using orphanRemoval
  6. Change Table Name of an Entity on runtime? [duplicate]
  7. Difference between FetchType LAZY and EAGER in Java Persistence API?
  8. How to map a composite key with JPA and Hibernate?
  9. How to map an entity field whose name is a reserved word in JPA
  10. Do I need elements in persistence.xml?
  11. What’s the difference between JPA and Hibernate? [closed]
  12. What is the “owning side” in an ORM mapping?
  13. What is the solution for the N+1 issue in JPA and Hibernate?
  14. What is the difference between persist() and merge() in JPA and Hibernate?
  15. How can I validate two or more fields in combination?
  16. JPQL Create new Object In Select Statement – avoid or embrace?
  17. What is the difference between Unidirectional and Bidirectional JPA and Hibernate associations?
  18. JPA: How to have one-to-many relation of the same Entity type
  19. JPA/Hibernate Native Queries do not recognize Parameters
  20. How to solve the LazyInitializationException when using JPA and Hibernate
  21. JPA: unidirectional many-to-one and cascading delete
  22. JPA – Persisting a One to Many relationship
  23. JPA: Implementing Model Hierarchy – @MappedSuperclass vs. @Inheritance
  24. Is there such thing CASE expression in JPQL?
  25. Doing an “IN” query with Hibernate
  26. The onFlushDirty Hibernate Interceptor method is never called
  27. How to map a map JSON column to Java Object with JPA
  28. Difference between @MapKey, @MapKeyColumn and @MapKeyJoinColumn in JPA and Hibernate
  29. Batch inserts with JPA/EJB3
  30. Does JPA support mapping to sql views?

Leave a Comment