Re: streaming result sets: progress

slamb writes:
> Okay, I understand now. The confusion is, you wrote this:
>
>       Statement st = connection.createStatement(
>               ResultSet.CLOSE_CURSORS_AT_COMMIT,
>               ResultSet.CONCUR_READ_ONLY);
>
> but evil gnomes changed the bits in my copy of the email to what I
> expected, so I didn't notice a difference. ;) I meant this:
>
>       Statement st = connection.createStatement(
>               ResultSet.TYPE_FORWARD_ONLY,
>               ResultSet.CONCUR_READ_ONLY,
>               ResultSet.CLOSE_CURSORS_AT_COMMIT);
>
> Type, concurrency, and holdability are all orthogonal parameters to
> createStatement and prepareStatement.

I've looked into this a bit more... I'm not gonna do this right now
because this call is only JDBC3 compatible.

We'll have to stick with the fetch size method I think.


Nic