Oracle Dialect doesn't support more than 1000 elements

Solution Unverified - Updated -

Issue

  • Exception: HHH000443: Dialect [org.hibernate.dialect.Oracle10gDialect] limits the number of elements in an IN predicate to 1000 entries.

The given parameter list [xyz] contained xxx entries, which will likely cause failures to execute the query in the database.
Note: xxx can be any number greater 1000.

Environment

  • JBoss Enterprise Application Server (EAP) 6
    • Hibernate

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content