using array in JPQL query

Question

How can I use an array list in JPQL query? I want something like this: I am passing this

private static final String[] MASKS = {"30109", "30111"};

into

public List<Account> findAccount(String[] Masks){
StringBuilder sb = new StringBuilder("from AccountTable a where SUBSTRING(a.Account,1,5) in :Masks ");
Query q = em.createQuery(sb.toString(), AccountTable.class)
                .setParameter("Masks",Masks);
}

currently, error is

Encountered array-valued parameter binding, but was expecting [java.lang.String (n/a)]; nested exception is java.lang.IllegalArgumentException: Encountered array-valued parameter binding, but was expecting [java.lang.String (n/a)]

Alex S. Diaz · Accepted Answer · 2015-07-23 07:54:43Z

24

Reading this site it seems that is possible, but your array must be a Collection, maybe something like this:

public List<Account> findAccount(String[] Masks){
    StringBuilder sb = new StringBuilder("from AccountTable a where SUBSTRING(a.Account,1,5) in :Masks ");
    Query q = em.createQuery(sb.toString(), AccountTable.class)
                .setParameter("Masks", Arrays.asList(MASKS));
}

Should help you.

answered Jul 23, 2015 at 7:54

Alex S. Diaz

2,6772 gold badges25 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

rakamakafo Over a year ago

Exactly what I need. Thanks

Collectives™ on Stack Overflow

using array in JPQL query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related