steve wrote:
you need to read the document regarding Query.iterate()
iterate() essentially performs a "shallow query" first for entity returns to just get their ids. As you iterate over the returned iterator, Hibernate then does additional selects to initialize the entities. obviously this is not possible in situations where you supply the sql query to be used.
I see, so what I'm doing wouldn't solve iterate, because it's not what 'iterate' does for a query.
However, is what I'm doing acceptable with respect to interacting with the ScrollableResults?
Anyway, thanks for the Info.