Exception while passing a list to javax.persistent.query object

Question

I have query

"SELECT I.INDIVIDUAL_CASE_ID,D.ASSISTER_ID,I.FIRSTNAME,I.LASTNAME,D.LAST_UPDATE_TIMESTAMP,I.ELIGIBILITY_STATUS,I.INDIVIDUAL_CASE_ID," +
               "I.NUMBEROFHOUSEHOLDMEMBERS,I.HOUSEHOLD_INCOME FROM  EXTERNAL_INDIVIDUAL I, EE_DESIGNATE_ASSISTERS D " +
               "WHERE I.INDIVIDUAL_CASE_ID = D.INDIVIDUAL_ID AND D.ASSISTER_ID=:assisterId AND D.INDIVIDUAL_ID IN (:individualIds)";

I am passing the parameter like

query = em.createNativeQuery(queryStr);
query.setParameter("assisterId", assisterId);
query.setParameter("individualIds",indvIdList);

But I am getting exception as

SEVERE: Servlet.service() for servlet [appServlet] in context with path [/ghix-entity] threw exception [Request processing failed; nested exception is
java.lang.IllegalArgumentException: org.hibernate.QueryParameterException: could not locate named parameter [individualIds]] with root cause
org.hibernate.QueryParameterException: could not locate named parameter [individualIds]
    at org.hibernate.engine.query.ParameterMetadata.getNamedParameterDescriptor(ParameterMetadata.java:101)

Any reason you are using a native query instead of a JPQL query which might support accepting a collection of parameters? — Chris, May 29 '14 at 15:07

score 1 · Answer 1 · edited May 23 '17 at 12:11

Native queries do not recognize Named parameters. Please see below link seems like similar question: JPA/Hibernate Native Queries do not recognize Parameters

Try : "SELECT I.INDIVIDUAL_CASE_ID,D.ASSISTER_ID,I.FIRSTNAME,I.LASTNAME,D.LAST_UPDATE_TIMESTAM‌P,I.ELIGIBILITY_STATUS,I.INDIVIDUAL_CASE_ID," + "I.NUMBEROFHOUSEHOLDMEMBERS,I.HOUSEHOLD_INCOME FROM EXTERNAL_INDIVIDUAL I, EE_DESIGNATE_ASSISTERS D " + "WHERE I.INDIVIDUAL_CASE_ID = D.INDIVIDUAL_ID AND D.ASSISTER_ID=?1 AND D.INDIVIDUAL_ID IN (?2)";

query = em.createNativeQuery(queryStr); 
query.setParameter(1, assisterId); 
query.setParameter(2,indvIdList);

score 0 · Answer 2 · answered May 29 '14 at 14:12

If you use Hibernate and not other JPA implementation than:

You can obtain the Hibernate Session from the entityManager:

Session session = entityManager.unwrap(Session.class);

And then you can use named parameters:

List result = 
    session.createSQLQuery(
            "SELECT I.INDIVIDUAL_CASE_ID,D.ASSISTER_ID,I.FIRSTNAME,I.LASTNAME,D.LAST_UPDATE_TIMESTAMP,I.ELIGIBILITY_STATUS,I.INDIVIDUAL_CASE_ID," +
                    "I.NUMBEROFHOUSEHOLDMEMBERS,I.HOUSEHOLD_INCOME FROM  EXTERNAL_INDIVIDUAL I, EE_DESIGNATE_ASSISTERS D " +
                    "WHERE I.INDIVIDUAL_CASE_ID = D.INDIVIDUAL_ID AND D.ASSISTER_ID=:assisterId AND D.INDIVIDUAL_ID IN (:individualIds)"
    )
    .setLong("assisterId", assisterId)
    .setParameterList("individualIds", indvIdList)
    .list();

score 0 · Answer 3 · answered May 29 '14 at 16:40

0

It was my issue. I was setting some extra parameters in the query object by mistake.After removing that the list is working fine.Thanks for all your suggestion

answered May 29 '14 at 16:40

Programmer

713
1
8
23

Exception while passing a list to javax.persistent.query object

3 Answers3