I was trying to set the start and end index and return an iterator via a broker.getIteratorByQuery(query)
After some code examination I determined that the indexes are only used in the getCollectionByQuery method. Perhaps we could add a comment to the javadoc for the setStartAtIndex and setEndAtIndex explaining this. Wally -----Original Message----- From: Mykola Ostapchuk [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 7:54 PM To: OJB Users List Subject: Re: setStartAtIndex and setEndAtIndex Works fine for me, I'm using rc4 and MSSQL with microsoft jdbc driver too. Here's code I'm using: Collection results = null; query.setStartAtIndex(offset); query.setEndAtIndex(offset+recordsPerPage); results = (Collection) broker.getCollectionByQuery(query); Regards, Mykola ----- Original Message ----- From: "Gelhar, Wallace Joseph" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Thursday, July 31, 2003 11:11 AM Subject: setStartAtIndex and setEndAtIndex >Hi, >I'm trying to implement paging using setStartAtIndex and setEndAtIndex >using RC4 against MSSQL with the microsoft jdbc driver. The query is >still returning a full resultset regardless of what I set. Has anyone >gotten this to work using this combination? >Wally --------------------------------------------------------------------- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
