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
