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