The SQL IN clase is limited to 1000 items in Oracle database. When writing HQL or Criteria, we have to keep this in mind and separate IN clauses with more items into several IN clauses (criteria) for instance by using the OR clause (criterion).
Could this be solved transparently by Hibernate? I mean that we would write the HQL IN clause normally, and the underlining Oracle dialect would take care of separating the long IN clauses in the generated native SQL.
Minor
The SQL IN clase is limited to 1000 items in Oracle database. When writing HQL or Criteria, we have to keep this in mind and separate IN clauses with more items into several IN clauses (criteria) for instance by using the OR clause (criterion).
Could this be solved transparently by Hibernate? I mean that we would write the HQL IN clause normally, and the underlining Oracle dialect would take care of separating the long IN clauses in the generated native SQL.