Re: Memory issue

From: Frank Brouwer (frank.brouwer_at_trimergo.nl)
Date: 10/07/03 

Date: Tue, 7 Oct 2003 17:52:32 +0200

Hi James,

"James" <jamestthomas@comcast.net> wrote in message
news:9OAgb.516621$cF.185652@rwcrnsc53...
> Can you post a complete example of your call to the database. Are you
> connection pooling? Are you releasing connections back into the pool or
is
> the pool growing too large? Are you manipulating arrays - any dangling
> references? The data coming back - is it huge? Are any result sets
hanging
> around? Just a few questions that may spark something.
>

I'm not using a pool and use prepared statements only, the close() method's
are invoked when needed. The resultSet is evaluated in a loop and the data
is put into objects which are passed as an Enumeration or Iterator to the
caller. But even if all your suggestions would be the case, it does not
explain why it works on a computer with limited resources (like a note-book)
and not on a machine with plenty resources (big server).

Thanks for thinking with me,

Frank.

Relevant Pages