Subject Re: [Firebird-Java] GDS Exception: Cursor unknown
Author Roman Rokytskyy
> If I need to commit while going through a ResultSet, I'll use two
> connections and set the transaction isolation to whatever is
> appropriate.

That's the correct solution.

> Would it be valid to set the fetch size to 103,000 (ignoring issues
> of client memory usage, network, etc) to work around this?

Most likely - no, but try. With this version of the driver you can use
TYPE_SCROLL_INSENSITIVE result sets to cache data on the client. But I think
I will fix this in the next version of the driver :)

Roman