Postgres Pro
Downloads
Home   >   mailing lists

Re: java.lang.OutOfMemoryError: GC overhead limit exceeded - Mailing list pgsql-jdbc

From Thomas Kellerer
Subject Re: java.lang.OutOfMemoryError: GC overhead limit exceeded
Date
Msg-id 322cce1b-6e78-ace4-f7c0-be07be5346ce@gmx.net
Whole thread Raw
In response to java.lang.OutOfMemoryError: GC overhead limit exceeded  (Christophe combet <chrisc_pro@yahoo.fr>)
List pgsql-jdbc
Tree view 
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

pgsql-jdbc by date:

Previous
From: Christophe combet
Date:
Subject: Re: java.lang.OutOfMemoryError: GC overhead limit exceeded
Next
From: Vladimir Sitnikov
Date:
Subject: Re: java.lang.OutOfMemoryError: GC overhead limit exceeded