Adding IN clause List to a JPA Query Adding IN clause List to a JPA Query java java

Adding IN clause List to a JPA Query


java jpa jpql

When using IN with a collection-valued parameter you don't need (...):

@NamedQuery(name = "EventLog.viewDatesInclude",     query = "SELECT el FROM EventLog el WHERE el.timeMark >= :dateFrom AND "     + "el.timeMark <= :dateTo AND "     + "el.name IN :inclList")

java jpa jpql

The proper JPA query format would be:

el.name IN :inclList

If you're using an older version of Hibernate as your provider you have to write:

el.name IN (:inclList)

but that is a bug (HHH-5126) (EDIT: which has been resolved by now).

java jpa jpql 

public List<DealInfo> getDealInfos(List<String> dealIds) {        String queryStr = "SELECT NEW com.admin.entity.DealInfo(deal.url, deal.url, deal.url, deal.url, deal.price, deal.value) " + "FROM Deal AS deal where deal.id in :inclList";        TypedQuery<DealInfo> query = em.createQuery(queryStr, DealInfo.class);        query.setParameter("inclList", dealIds);        return query.getResultList();    }

Works for me with JPA 2, Jboss 7.0.2

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last