JPA CriteriaBuilder – How to use “IN” comparison operator

by

If I understand well, you want to Join ScheduleRequest with User and apply the in clause to the userName property of the entity User.

I’d need to work a bit on this schema. But you can try with this trick, that is much more readable than the code you posted, and avoids the Join part (because it handles the Join logic outside the Criteria Query).

List<String> myList = new ArrayList<String> ();
for (User u : usersList) {
    myList.add(u.getUsername());
}
Expression<String> exp = scheduleRequest.get("createdBy");
Predicate predicate = exp.in(myList);
criteria.where(predicate);

In order to write more type-safe code you could also use Metamodel by replacing this line:

Expression<String> exp = scheduleRequest.get("createdBy");

with this:

Expression<String> exp = scheduleRequest.get(ScheduleRequest_.createdBy);

If it works, then you may try to add the Join logic into the Criteria Query. But right now I can’t test it, so I prefer to see if somebody else wants to try.

More Related Contents:

  1. JPA 2.0 many-to-many with extra column
  2. How to use JPA2’s @Cacheable instead of Hibernate’s @Cache
  3. JPA CascadeType.ALL does not delete orphans
  4. Hibernate – @ElementCollection – Strange delete/insert behavior
  5. @OrderColumn annotation in Hibernate 3.5
  6. JPQL Constructor Expression – org.hibernate.hql.ast.QuerySyntaxException:Table is not mapped
  7. Hibernate throws org.hibernate.AnnotationException: No identifier specified for entity: com..domain.idea.MAE_MFEView
  8. What is referencedColumnName used for in JPA?
  9. How do I properly cascade save a one-to-one, bidirectional relationship on primary key in Hibernate 3.6
  10. Hibernate triggering constraint violations using orphanRemoval
  11. Change Table Name of an Entity on runtime? [duplicate]
  12. Persist java.time.Instant (JDK8) with JPA2/Hibernate
  13. When and why JPA entities should implement the Serializable interface?
  14. JPQL Create new Object In Select Statement – avoid or embrace?
  15. What is the difference between Unidirectional and Bidirectional JPA and Hibernate associations?
  16. How to remove entity with ManyToMany relationship in JPA (and corresponding join table rows)?
  17. Hibernate: one-to-one lazy loading, optional = false
  18. JPA/Hibernate Native Queries do not recognize Parameters
  19. Getting Database connection in pure JPA setup
  20. Hibernate/JPA – annotating bean methods vs fields [duplicate]
  21. Spring Boot & Spring Data: how are Hibernate Sessions managed?
  22. Hibernate – why use many-to-one to represent a one-to-one?
  23. Silently ignored remove()
  24. JPA Criteria builder IN clause query
  25. Is it possible to dynamically define column names in Hibernate / JPA?
  26. Invalidating JPA EntityManager session
  27. Batch inserts with JPA/EJB3
  28. Hibernate inserts duplicates into a @OneToMany collection
  29. Hibernate vs JPA vs JDO – pros and cons of each? [closed]
  30. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB

Leave a Comment