0

I have a JPQL NamedQuery with several parameters With one parameter executing would look like 

private String a; //Getter setter for a
em.createNamedQuery("NamedQueryName").setParameter("param", a)

How can I do that with more that One parameter ?

Kurt Miller
  • 567
  • 1
  • 8
  • 23
  • 2
    `EntityManager#createNamedQuery` follows the builder pattern. `setParameter` returns the `TypedQuery` object so you can simply chain the `setParameter` calls. `setParameter().setParameter()...` – thst Mar 16 '16 at 23:45

1 Answers1

1

Please find below solution
replace <Entityname> with entity name and <namedQuery> with the named Query

 Query query = createNamedQuery("<Entityname>.<namedQuery>");
 query.setParameter("column1", value1);
 query.setParameter("column2", value2);
 query.setParameter("column3", value3);
 query.getSingleResult()
Mr Lister
  • 45,515
  • 15
  • 108
  • 150
Shivani Naren
  • 26
  • 1