Oracle limitation: large "where x in (....)' -------------------------------------------- Key: HB-655 URL: http://opensource.atlassian.com/projects/hibernate/browse/HB-655 Project: Hibernate2 Type: Improvement

Components: core Versions: 2.1.1 Environment: Hibernate 2.1.1 Oracle 8i Reporter: Christian Gruber Assignee: Emmanuel Bernard

Hello! There is a problem with queries with named parameters that consist of big lists with Oracle. An example: Collection idList = new LinkedList(); for (int i=0; i<1001; i++) { idList.add(new Integer(i)); } Query query = session.createQuery("from Geneticelem as geneticelem where geneticelem.id in (:ids)"); query.setParameterList("ids", idList, Hibernate.INTEGER); Iterator geneticelems = query.iterate(); This code results in an ORA-01795 exception, because not more than 1000 elements are allowed for "in". In OJB, this is solved by splitting the "in" condition is split up in chunks: http://db.apache.org/ojb/api/org/apache/ojb/broker/query/Criteria.html#ad... Can something like this also be implemented in Hibernate? I know, it's a limitation that will rarely be encountered, but still it's a limitation. Thanks, Christian