[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2594) org.hibernate.criterion.Restrictions.in(?) should break up lists of 1000+ items, Oracle Dialect

[Nathan Silberman (JIRA)]

org.hibernate.criterion.Restrictions.in(?) should break up lists of 1000+ items, Oracle Dialect
-----------------------------------------------------------------------------------------------

                 Key: HHH-2594
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2594
             Project: Hibernate3
          Issue Type: Improvement
          Components: query-hql
    Affects Versions: 3.2.0.cr2
         Environment: Hibernate 3.2cr2, Oracle DB
            Reporter: Nathan Silberman
            Priority: Minor


Given a Restriction criteria, if an Array or Collection is passed into the 'in' method, an error is thrown by Oracle complaining that an IN clause must contain at most 1000 items. 

The Oracle Dialect should be able to segment these items into multiple IN clauses of at most 1000 items each.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira