db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amir Michail" <amich...@gmail.com>
Subject Re: strange out of memory exception
Date Thu, 04 Jan 2007 23:40:45 GMT
On 1/4/07, Amir Michail <amichail@gmail.com> wrote:
> Hi,
> I'm getting this exception:
> java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ040,
> SQLERRMC: Failed to start database 'myDB', see the next exception for
> details.::SQLSTATE: XJ001Java exception: 'Java heap space:
> java.lang.OutOfMemoryError'.

Please ignore. I solved the problem.

BTW, how long should a servlet hold on to a db connection? Should it
open a connection for each request? Or is it sufficient to just open a
connection once? Does it matter in terms of reliability of the db,
resource limits, etc.?


> Any ideas on how to debug this and/or increase the memory available?
> There isn't much data in the db btw.
> Amir

View raw message