openjpa-users mailing list archives

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

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 (t.id=? OR t.id=? OR t.id=? ...)
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
happening?

Thanks,

Mylène

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