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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.