I know I can pass a list to named query in JPA, but how about NamedNativeQuery? I have tried many ways but still can&#39;t just pass the list to a NamedNativeQuery. Anyone know how to pass a list to the in clause in NamedNativeQuery? Thank you very much!

The NamedNativeQuery is as below:

    @NamedNativeQuery(
       name=&quot;User.findByUserIdList&quot;, 
       query=&quot;select u.user_id, u.dob, u.name, u.sex, u.address from user u &quot;+
             &quot;where u.user_id in (?userIdList)&quot;
    )

and it is called like this:

    List&lt;Object[]&gt; userList = em.createNamedQuery(&quot;User.findByUserIdList&quot;).setParameter(&quot;userIdList&quot;, list).getResultList();

However the result is not as I expected.

    System.out.println(userList.size());  //output 1

    Object[] user = userList.get(0);
    System.out.println(user.length);   //expected 5 but result is 3
    System.out.println(user[0]);       //output MDAVERSION which is not a user_id
    System.out.println(user[1]);       //output 5
    System.out.println(user[2]);       //output 7


All Nativequery Solutions on Gang of Coders

Total of 1 Nativequery Solutions

JPA passing list to IN clause in named native query