SyntaxFix

[java] Hibernate HQL Query : How to set a Collection as a named parameter of a Query?

I'm not sure about HQL, but in JPA you just call the query's setParameter with the parameter and collection.

Query q = entityManager.createQuery("SELECT p FROM Peron p WHERE name IN (:names)");
q.setParameter("names", names);

where names is the collection of names you're searching for

Collection<String> names = new ArrayList<String();
names.add("Joe");
names.add("Jane");
names.add("Bob");

Examples related to java

• Under what circumstances can I call findViewById with an Options Menu / Action Bar item? • How much should a function trust another function • How to implement a simple scenario the OO way • Two constructors • How do I get some variable from another class in Java? • this in equals method • How to split a string in two and store it in a field • How to do perspective fixing? • String index out of range: 4 • My eclipse won't open, i download the bundle pack it keeps saying error log

Examples related to hibernate

• Hibernate Error executing DDL via JDBC Statement • How does spring.jpa.hibernate.ddl-auto property exactly work in Spring? • Error creating bean with name 'entityManagerFactory' defined in class path resource : Invocation of init method failed • JPA Hibernate Persistence exception [PersistenceUnit: default] Unable to build Hibernate SessionFactory • Disable all Database related auto configuration in Spring Boot • Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] • HikariCP - connection is not available • Hibernate-sequence doesn't exist • How to find distinct rows with field in list using JPA and Spring? • Spring Data JPA and Exists query

Examples related to hql

• Difference between INNER JOIN and LEFT SEMI JOIN • [Ljava.lang.Object; cannot be cast to • HQL Hibernate INNER JOIN • What is the difference between JOIN and JOIN FETCH when using JPA and Hibernate • IN-clause in HQL or Java Persistence Query Language • ORDER BY using Criteria API • How do you do a limit query in JPQL or HQL? • Hibernate HQL Query : How to set a Collection as a named parameter of a Query? • How do you create a Distinct query in HQL • JPA and Hibernate - Criteria vs. JPQL or HQL