Oliver Jowett wrote on 27.03.2011 16:15:
>> At the top of my list is the need to use a cursor to avoid
>> materializing the entire result set in heap during execution of an
>> execute method. Pulling data off the wire should be done in
>> ResultSet.next() method.
>
> Do you mean something beyond the batching you can do by setting a
> suitable fetchsize?
> Or do you mean you want to lift the restrictions on when that batching
> can actually be used?
> Or something else?
>
I agree with Dave here.
Having a default that prevent the entire result to be loaded into the client memory does make a lot of sense to me.
Regards
Thomas