Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
Message-ID: <486E4374.9090503@amberpoint.com>
Date: Fri, 04 Jul 2008 08:36:20 -0700
From: Bryan Pendleton <bpendleton@amberpoint.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: OutOfMemory
References: <18db29d30807040829p1ad8b24ag9f7307f3eec0bd9b@mail.gmail.com>
In-Reply-To: <18db29d30807040829p1ad8b24ag9f7307f3eec0bd9b@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

> I am getting into an OutOfMemory error in my case. Which is similar to 
> the case below. After examining the heap dump, I could find the 
> PreparedStatement is hold too many internal objects and might lead to 
> the MemoryLeak.
> I am not for sure whether it is caused by my closing the statement after 
> the long loop, thus causing the client side of derby cashing too many 
> things. Will that be the problem? Thanks.

What are the internal objects which are held? Since you've looked at
your memory dump, can you post the number of instances of the various
classes at the top of the list?

Also, can you re-arrange your application to be able to commit during
the loop? A single transaction cannot be arbitrarily large, as there
are some resources that cannot be freed until the commit occurs.

thanks,

bryan