To do partial fetches you must turn autocommit off. See:
Yup, that did it. I suppose there is a reason why no exception is thrown at the execute, or an error for the setFetchSize when autocommit is still on?http://jdbc.postgresql.org/documentation/83/query.html#query-with-cursor Kris Jurka