Setting a parameter as a list for an IN expression

by

Your JPQL is invalid, remove the brackets

List<String> logins = em.createQuery("SELECT a.accountManager.loginName " +
    "FROM Account a " +
    "WHERE a.id IN :ids")
    .setParameter("ids",Arrays.asList(new Long(1000100), new Long(1000110)))
    .getResultList();

More Related Contents:

  1. JPQL Create new Object In Select Statement – avoid or embrace?
  2. Adding IN clause List to a JPA Query
  3. Parameter in like clause JPQL
  4. How to use multiple JOIN FETCH in one JPQL query
  5. Limit number of results in JPQL
  6. How To Define a JPA Repository Query with a Join
  7. Using the JPA Criteria API, can you do a fetch join that results in only one join?
  8. Doing an “IN” query with Hibernate
  9. JPQL: Receiving a Collection in a Constructor Expression
  10. How can I avoid the Warning “firstResult/maxResults specified with collection fetch; applying in memory!” when using Hibernate?
  11. Sharing a persistence unit across components in a .ear file
  12. IN-clause in HQL or Java Persistence Query Language
  13. JPA Native Query select and cast object
  14. Spring Data JPA and Exists query
  15. JPQL Like Case Insensitive
  16. JPA: JOIN in JPQL
  17. How to create a JPA query with LEFT OUTER JOIN
  18. What’s the difference between the IN and MEMBER OF JPQL operators?
  19. Java, JPA, Glassfish, Invalid resource : jdbc/__default__pm
  20. JPA Select latest instance for each item
  21. Name attribute in @Entity and @Table
  22. One-To-Many Relationship with Join Table
  23. Why should anybody put annotations on the getters or setters when using JPA to map the classes?
  24. How to configure transaction management for working with 2 different db in Spring?
  25. Hibernate using JPA (annotated Entities) and liquibase
  26. Mapping JPA or Hibernate projection query to DTO (Data Transfer Object)
  27. JPA: Override Auto generated ID [duplicate]
  28. JPA Native Query set null parameter
  29. javax.persistence.TransactionRequiredException in small facelet application
  30. TransactionRequiredException Executing an update/delete query

Leave a Comment