Re: Streaming ResultSet

Kevin Grittner wrote:

> The disadvantages of the current default approach are:

> (2) You might want to see partial results from a query which ultimately
> generates an exception.

I don't see this is something that any sort of portable application is
ever going to need. It's very unpredictable where you get an error if an
error occurs, since it's so dependent on backend / driver / protocol
implementations.

> The disadvantages of the cursored approach are:

> (1) It might not be easy to create all of the right conditions for the
> cursored approach to work.

It occurs to me that the only condition that streaming would mitigate is
having to have autocommit off.

You can't usefully use streaming with TYPE_SCROLLABLE_* resultsets as
even though you can stream results just fine while the resultset
current-row is moving strictly forward, you have to keep all previously
retrieved results in memory anyway in case the application asks to move
backwards (perfectly legal with a SCROLLABLE resultset). Keeping the
whole resultset in memory defeats the purpose of streaming in the first
place..

-O