| From: | Luca Ferrari <fluca1978(at)gmail(dot)com> |
|---|---|
| To: | Rashmi V Bharadwaj <rvbharad(at)in(dot)ibm(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Cursors for PGJDBC queries |
| Date: | 2019-08-01 07:30:29 |
| Message-ID: | CAKoxK+5fCmP4zgAxwqwpg9W_Se4OZ8crfRxzpkEeCZ3QeVo9gQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Aug 1, 2019 at 9:10 AM Rashmi V Bharadwaj <rvbharad(at)in(dot)ibm(dot)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/>.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luca Ferrari | 2019-08-01 07:32:00 | Re: Cursors for PGJDBC queries |
| Previous Message | Rashmi V Bharadwaj | 2019-08-01 07:10:10 | Cursors for PGJDBC queries |