Re: java.lang.OutOfMemoryError: GC overhead limit exceeded

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To: pgsql-jdbc(at)lists(dot)postgresql(dot)org
Subject: Re: java.lang.OutOfMemoryError: GC overhead limit exceeded
Date: 2020-07-23 17:32:48
Message-ID: 322cce1b-6e78-ace4-f7c0-be07be5346ce@gmx.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


Christophe combet schrieb am 23.07.2020 um 17:41:
> Indeed, the autocommit=false + fetchSize combo is working. I did a
> mistake when trying the first time as suggested by Vladimir: I used
> createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY)
> which are not the good parameters to be used (bad copy/paste).

You would need

createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY)

Thomas

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Vladimir Sitnikov 2020-07-23 18:03:45 Re: java.lang.OutOfMemoryError: GC overhead limit exceeded
Previous Message Christophe combet 2020-07-23 16:23:16 Re: java.lang.OutOfMemoryError: GC overhead limit exceeded