Re: Cursors and Transactions, why?

On Apr 7, 2004, at 2:01 PM, Kris Jurka wrote:

> The 7.4 jdbc driver has the ability to use cursors behind the scenes on
> queries.  This is done by calling Statement.setFetchSize(n) to
> retrieve n
> rows at a time.  There are a number of other restrictions: you must be
> in
> a transaction and the ResultSet type must be FORWARD_ONLY.  You can use
> the 7.4 jdbc driver against a 7.3 server as well so this may provide
> some
> relief.

I remember reading about this long ago.  It's not really an option in
my little world because of the open transaction bit.  My solution is
eventually going to be to upgrade to 7.4... heh, probably about the
time 7.5 is released.  *sigh*

eric