agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] java.lang.OutOfMemoryError
Date: Wed, 28 Jun 2006 12:39:05 +0200
Message-ID: <44A25C49.6010907@tada.se> (raw)
In-Reply-To: <44A258BA.10605@insa-toulouse.fr>
References: <4492740D.4040302@insa-toulouse.fr>
	<4492BB01.5060205@tada.se>
	<44965774.7050203@insa-toulouse.fr>
	<44966070.4040806@tada.se>
	<44A134C6.5030003@insa-toulouse.fr>
	<44A13A99.60406@tada.se>
	<44A258BA.10605@insa-toulouse.fr>

Hi Eric,
Some followup questions inline:

Eric BOYER wrote:
> I will try to explain what are we doing :
> We wan't to insert data in a db postgres.
> The data come from a LDAP and concern information about computer account.
> We are connected to the LDAP and inject data in our db.
Is this connection established from within a PL/Java function or do you 
have a client application for that?

> In this db, triggers insert some data in the same db but bot in the 
> same table which can launch triggers again, etc ...
>
> Finally, we generate a new LDAP and an Active Directory !
>
> We have about 5000 people to insert.
How big is your transaction? Is it one insert per commit or do you 
insert them all in one go?

> with 512, it's OK
> for exemple for 256 , it crash for about 2000 account
> when we use 128, it crash earlier
>
Sounds like each account consumes 100k of memory or more. Memory that 
are never released. Do you have any static variables in your classes 
(Map's List's etc.) that might hold on to the data? Are you careful to 
close your ResultSet and Statements using try/finally clauses?

Regards,
Thomas Hallgren

view thread (14+ messages)  latest in thread

Message-ID: <44A25C49.6010907@tada.se>
Permalink:  ../44A25C49.6010907@tada.se/
Also on:    postgresql.org/message-id/44A25C49.6010907@tada.se

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] java.lang.OutOfMemoryError
  In-Reply-To: <44A25C49.6010907@tada.se>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox