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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
