Faced this problem too. Hibernate 4.3.5. We face this even harder because we use oracle and so have to use ((a IN (:a1)) OR (a IN (:a2))) where max size of each collection in [a1, a2 ... an] is 1000. And we have to generate these queries dynamically.