are there any oracle experts that could shed some light on this. the actual code should not bring back all the results and only return a subset, but rather it should use the ResultSet.absolute method to bop around and only retrieve the objects it needs. This code is in RsIterator and PersistenceBrokerImpl
anyone? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 9:29 AM To: OJB Users List Subject: RE: Using setStartAtIndex with Oracle 8i Hi, I think when you use setStartIndex method, all the results are retrieved from DB and then your query returns only the subset that you specified. I ran into that problem too and I had to add an additional criteria to my query : Criteria crit = new Criteria(); crit.addSql("rownum < 100"); Query q = QueryFactory.newQuery(Foo.class, crit); Collection c = broker.getCollectionByQuery(q); The problem is that it uses oracle specific stuff. But at least, performance is much better ! Hope that helps, Thomas --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
