Doing an “IN” query with Hibernate

by

The syntax of your JPQL query is incorrect. Either use (with a positional parameter):

List<Long> ids = Arrays.asList(380L, 382L, 386L);
Query query = em.createQuery("FROM TrackedItem item WHERE item.id IN (?1)");
query.setParameterList(1, ids)
List<TrackedItem> items = query.getResultList();

Or (with a named parameter):

List<Long> ids = Arrays.asList(380L, 382L, 386L);
Query query = em.createQuery("FROM TrackedItem item WHERE item.id IN :ids");
query.setParameterList("ids", ids)
List<TrackedItem> items = query.getResultList();

Below, the relevant sections of the JPA 1.0 specification about parameters:

4.6.4.1 Positional Parameters

The following rules apply to positional parameters.

  • Input parameters are designated by the question mark (?) prefix followed by an integer. For example: ?1.
  • Input parameters are numbered starting from 1.
    Note that the same parameter can be used more than once in the query string and that the ordering of the use of parameters within the query string need not conform to the order of the positional parameters.

4.6.4.2 Named Parameters

A named parameter is an identifier that is prefixed by the “:” symbol. It follows the rules for identifiers defined in Section 4.4.1. Named parameters are case sensitive.

Example:

SELECT c
FROM Customer c
WHERE c.status = :stat

Section 3.6.1 describes the API for the binding of named query parameters

More Related Contents:

  1. JPQL Create new Object In Select Statement – avoid or embrace?
  2. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  3. Difference between FetchType LAZY and EAGER in Java Persistence API?
  4. How to map a composite key with JPA and Hibernate?
  5. How to map an entity field whose name is a reserved word in JPA
  6. Do I need elements in persistence.xml?
  7. What’s the difference between JPA and Hibernate? [closed]
  8. What is the “owning side” in an ORM mapping?
  9. What is the solution for the N+1 issue in JPA and Hibernate?
  10. JPA CascadeType.ALL does not delete orphans
  11. What is the difference between persist() and merge() in JPA and Hibernate?
  12. When and why JPA entities should implement the Serializable interface?
  13. What is the difference between Unidirectional and Bidirectional JPA and Hibernate associations?
  14. How to remove entity with ManyToMany relationship in JPA (and corresponding join table rows)?
  15. JPA/Hibernate Native Queries do not recognize Parameters
  16. How to solve the LazyInitializationException when using JPA and Hibernate
  17. I found JPA, or alike, don’t encourage DAO pattern
  18. Getting Database connection in pure JPA setup
  19. Hibernate/JPA – annotating bean methods vs fields [duplicate]
  20. How do I properly cascade save a one-to-one, bidirectional relationship on primary key in Hibernate 3.6
  21. JPA: Implementing Model Hierarchy – @MappedSuperclass vs. @Inheritance
  22. Is it possible to dynamically define column names in Hibernate / JPA?
  23. How To Define a JPA Repository Query with a Join
  24. How can I avoid the Warning “firstResult/maxResults specified with collection fetch; applying in memory!” when using Hibernate?
  25. The onFlushDirty Hibernate Interceptor method is never called
  26. Difference between @MapKey, @MapKeyColumn and @MapKeyJoinColumn in JPA and Hibernate
  27. Batch inserts with JPA/EJB3
  28. Hibernate triggering constraint violations using orphanRemoval
  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