Java out of memory using PostgreSQL

java postgresql memory

Set the fetch size to something reasonable (st.setFetchSize(rowCount)). You can experiment with this.
Put everything in a transaction with autocommit off (con.setAutoCommit(false)).

See this explanation and the documentation.