How to use setParameter (JPQL Namedquery) with multiple parameters

Question

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 ?

Answer 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()