Max number of collection elements for IN-clause with jpql

Question

I would like to know if there is a limit on the size of a collection when using the IN clause.

select a from A where a.b IN (:c)

and c is a list(for example).

score 3 · Accepted Answer · edited May 23 '17 at 09:59

3

It depends on the specific DBMS, ie. sqlite and postgres have widely different limits (not surprisingly).

EDIT:

edited May 23 '17 at 09:59

Community

answered Jan 26 '12 at 13:24

Savino Sguera

I'm using mysql for development and oracle for prod – Francesco Jan 26 '12 at 13:39
I am not able to answer about jpql-specific issues, if that was part of the question – Savino Sguera Jan 26 '12 at 13:44

1 Answers1