openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mylene <>
Subject select... where ... in
Date Wed, 16 Oct 2013 13:22:11 GMT

I have a CriteriaQuery, in which I build a "where id in  ids" kind of query.
Ids is ArrayList<Long>()
Database is Oracle 10.

I get an exception on a real long ArrayList (some 100.000 entries).
When I check the resulting query, it seems to be translated to

select * from table t where ( OR OR ...)
100.000 OR's seems overdone - and I guess that's why the query fails.

Is this normal OpenJPA behaviour, or does anyone have a clue what is



  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message