On Thu, Aug 1, 2019 at 9:10 AM Rashmi V Bharadwaj <rvbha...@in.ibm.com> wrote: > I am trying to set the fetch size for my ResultSet to avoid Out of Memory > exception. I have created the Statement with ResultSet.TYPE_FORWARD_ONLY, > ResultSet.CONCUR_READ_ONLY and ResultSet.HOLD_CURSORS_OVER_COMMIT and I've > also disabled auto commit as mentioned in the link Getting results based on a > cursor. I am still getting Out of memory error. My SQL query is a simple > SELECT statement to retrieve all the rows from a table. According to > https://postgrespro.com/list/thread-id/2370772, the holdability must be > CLOSE_CURSORS_AT_COMMIT. Could you please confirm this is a requirement?
Hard to say without more information. Could it be something you need to set on the jvm like However, you should post on the JDBC mailing list <https://www.postgresql.org/list/pgsql-jdbc/>.
