We're updating the issue view to help you get more done. 

Limit SQL in clause in Oracle dialects.

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.

Environment

Oracle database.

Status

Assignee

Unassigned

Reporter

Hamblivy

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Priority

Minor