> I'm surprised no one has yet suggested using a cursor. Some people don't use cursors because creating and using them requires db-specific code inside their otherwise vanilla JDBC. Of course, using LIMIT/OFFSET is also db-specific... David
pgsql-jdbc by date:
Соглашаюсь с условиями обработки персональных данных