Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > pgsql.interfaces.jdbc > #6

Re: PgResultSet accumulates fetched data and causes OutOfMemoryException

Newsgroups pgsql.interfaces.jdbc
Date 2017-05-25 03:19 -0700
References <e27a5018-6491-478c-92b6-fd07e0038328@googlegroups.com>
Message-ID <d31bfe35-db5f-410e-9c3a-1b6b2ef153f6@googlegroups.com> (permalink)
Subject Re: PgResultSet accumulates fetched data and causes OutOfMemoryException
From Rob Bygrave <robin.bygrave@gmail.com>

Show all headers | View raw


Have you tried this with raw JDBC?  

Setting setFetchSize() should be sufficient (at least from the last time I tested this). There are the hints ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY but they should not be required I believe.


> 42.0.0

That is a newer driver version though. I haven't tested this recently.

Back to pgsql.interfaces.jdbc | Previous | NextPrevious in thread | Next in thread | Find similar


Thread

PgResultSet accumulates fetched data and causes OutOfMemoryException frontengewitter@gmail.com - 2017-05-24 12:18 -0700
  Re: PgResultSet accumulates fetched data and causes OutOfMemoryException Rob Bygrave <robin.bygrave@gmail.com> - 2017-05-25 03:19 -0700
    Re: PgResultSet accumulates fetched data and causes OutOfMemoryException Matthias <frontengewitter@gmail.com> - 2017-05-26 00:44 -0700

csiph-web