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.setParameter(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.setParameter("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