JPQL IN clause: Java-Arrays (or Lists, Sets…)?

by

I’m not sure for JPA 1.0 but you can pass a Collection in JPA 2.0:

String qlString = "select item from Item item where item.name IN :names"; 
Query q = em.createQuery(qlString, Item.class);

List<String> names = Arrays.asList("foo", "bar");

q.setParameter("names", names);
List<Item> actual = q.getResultList();

assertNotNull(actual);
assertEquals(2, actual.size());

Tested with EclipseLInk. With Hibernate 3.5.1, you’ll need to surround the parameter with parenthesis:

String qlString = "select item from Item item where item.name IN (:names)";

But this is a bug, the JPQL query in the previous sample is valid JPQL. See HHH-5126.

More Related Contents:

  1. Using an ORM or plain SQL? [closed]
  2. JPQL Create new Object In Select Statement – avoid or embrace?
  3. What are the principles behind, and benefits of, the “party model”?
  4. How To Define a JPA Repository Query with a Join
  5. Best way to model Customer Address
  6. Doing an “IN” query with Hibernate
  7. JPA Native Query select and cast object
  8. How to use a dynamic parameter in a IN clause of a JPA named query?
  9. Redundant data in update statements
  10. How to select a record and update it, with a single queryset in Django?
  11. JPA Select latest instance for each item
  12. Does JPA support mapping to sql views?
  13. SQL Selecting from three tables
  14. How to cast the DateTime to Time
  15. Inner join vs Where
  16. Computed / calculated / virtual / derived columns in PostgreSQL
  17. Xcode 4 and Core Data: How to enable SQL Debugging
  18. How to use parameters “@” in an SQL command in VB
  19. SQL: parse the first, middle and last name from a fullname field
  20. How can you tell if a value is not numeric in Oracle?
  21. Call dynamic SQL from function
  22. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  23. How to unpivot in BigQuery?
  24. How to convert PostgreSQL 9.4’s jsonb type to float
  25. Find rows that have the same value on a column in MySQL
  26. Referencing current row in FILTER clause of window function
  27. What does ON [PRIMARY] mean?
  28. MySQL SELECT x FROM a WHERE NOT IN ( SELECT x FROM b ) – Unexpected result
  29. selecting top N rows for each group in a table
  30. Getting warning: Null value is eliminated by an aggregate or other SET operation

Leave a Comment