On 1/4/07, Amir Michail <[EMAIL PROTECTED]> 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.?
Amir
Any ideas on how to debug this and/or increase the memory available?
There isn't much data in the db btw.
Amir