Uploaded image for project: 'Hibernate ORM'
  1. HHH-9299

Limit SQL in clause in Oracle dialects.

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: query-criteria, query-hql
    • Labels:
      None
    • Environment:
      Oracle database.
    • Last commented by a user?:
      true
    • Sprint:

      Description

      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.

        Attachments

          Issue links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: