Is there any size limit in arraylist used in "where in" in java named query?
With Oracle 10g you can you use 1000. I think this is entirely database-specific as opposed to Java or JDBC specific.