> I'm surprised no one has yet suggested using a cursor.
Some people don't use cursors because creating and using them requiresdb-specific code inside their otherwise vanilla JDBC. Of course, usingLIMIT/OFFSET is also db-specific...
David