IN-clause in HQL or Java Persistence Query Language

by

Are you using Hibernate’s Query object, or JPA? For JPA, it should work fine:

String jpql = "from A where name in (:names)";
Query q = em.createQuery(jpql);
q.setParameter("names", l);

For Hibernate’s, you’ll need to use the setParameterList:

String hql = "from A where name in (:names)";
Query q = s.createQuery(hql);
q.setParameterList("names", l);

More Related Contents:

  1. JPQL Create new Object In Select Statement – avoid or embrace?
  2. How to use multiple JOIN FETCH in one JPQL query
  3. Doing an “IN” query with Hibernate
  4. How can I avoid the Warning “firstResult/maxResults specified with collection fetch; applying in memory!” when using Hibernate?
  5. Spring Data JPA and Exists query
  6. Difference between FetchType LAZY and EAGER in Java Persistence API?
  7. How to map an entity field whose name is a reserved word in JPA
  8. Why is Hibernate Open Session in View considered a bad practice?
  9. What’s the difference between JPA and Hibernate? [closed]
  10. How to convert a Hibernate proxy to a real entity object
  11. What is the solution for the N+1 issue in JPA and Hibernate?
  12. JPA CascadeType.ALL does not delete orphans
  13. Wrong ordering in generated table in jpa
  14. Solve Hibernate Lazy-Init issue with hibernate.enable_lazy_load_no_trans
  15. Hibernate criteria: Joining table without a mapped association
  16. Adding IN clause List to a JPA Query
  17. what is @JoinColumn and how it is used in Hibernate
  18. JPA eager fetch does not join
  19. In which case do you use the JPA @JoinTable annotation?
  20. JPA: Implementing Model Hierarchy – @MappedSuperclass vs. @Inheritance
  21. Setting a parameter as a list for an IN expression
  22. How to escape reserved words in Hibernate’s HQL
  23. Specifying an Index (Non-Unique Key) Using JPA
  24. Difference between save and saveAndFlush in Spring data jpa
  25. Inherited abstract class with JPA (+Hibernate)
  26. org.hibernate.MappingException: Could not determine type for: java.util.Set [duplicate]
  27. Difference between @MapKey, @MapKeyColumn and @MapKeyJoinColumn in JPA and Hibernate
  28. Why hibernate generates insert and update for OneToMany mapping
  29. Name attribute in @Entity and @Table
  30. JPA: Override Auto generated ID [duplicate]

Leave a Comment