Re: Cursors for PGJDBC queries

2019-08-01 Thread Thomas Kellerer
Rashmi V Bharadwaj schrieb am 01.08.2019 um 09:10: > 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 aut

Re: Cursors for PGJDBC queries

2019-08-01 Thread Luca Ferrari
On Thu, Aug 1, 2019 at 9:30 AM Luca Ferrari wrote: > Hard to say without more information. Could it be something you need > to set on the jvm like sorry, I was intended to write -Xms256m -Xmx1024m to adjust the jvm memory limits. Again I believe that the jdbc mailing list is the right place to as

Re: Cursors for PGJDBC queries

2019-08-01 Thread Luca Ferrari
On Thu, Aug 1, 2019 at 9:10 AM Rashmi V Bharadwaj 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 di

Cursors for PGJDBC queries

2019-08-01 Thread Rashmi V Bharadwaj
Hi,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