CODEWITHSUNDEEP
sqljpql
Francesco
Francesco

Reputation: 2382

Max number of collection elements for IN-clause with jpql

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).

Upvotes: 8

Views: 4395

Answers (1)

Savino Sguera
Savino Sguera

Reputation: 3572

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

EDIT:

For Oracle: How to put more than 1000 values into an Oracle IN clause

For mysql: http://explainextended.com/2009/08/18/passing-parameters-in-mysql-in-list-vs-temporary-table/

Upvotes: 4

Related Questions