Re: OutOfMemory hibernate scroll with 2M records | Postgresql 8.4 DB

On Mon, Dec 21, 2009 at 5:04 PM, Ankit Kumar <ankitk(at)xebia(dot)com> wrote:
> Thanks for your response. Hibernate works well when I change the DB to SQL
> server but somehow the moment I point to Postgresql it start generating
> OutOfMemory. Is there some configuration at DB end to ensure it starts using
> the cursors.

No Postgresql is not generating these errors -- they're Java errors
and Postgresql is not written in Java. You'll get better luck starting
with the top and working down. The Hibernate people -- I don't know
what their mailing list is -- can answer questions about what
Hibernate does differently for MSSQL versus Postgres. If they say it's
doing the same thing then once you're clear on what that is that it's
doing you can speak to the JDBC Postgresql driver people
(pgsql-jdbc(at)postgresql(dot)org) and ask whether they handle that case
poorly. But if you start with the jdbc people and you can't answer
questions about what Hibernate is doing then they're not going to know
how to help (unless they've seen it before I guess).

--
greg