-----Mensaje original-----
De: Roman Rokytskyy [mailto:rrokytskyy@...]
Enviado el: Martes, 10 de Junio de 2003 08:08 p.m.
Para: Firebird-Java@yahoogroups.com
Asunto: [Firebird-Java] Re: IBServer memory problem

Hi,

> Once I start up Tomcat I execute the following piece of code every
> 10 seconds (using a thread). Ibserver starts up with x amount of
> memory and stays like that for about a minute. After that the
> process starts acquiring memory (about 50k every cycle) unitl
> crashing the server. Could  someone please tell me why this could be
> happening.

What about ps.close() before you do the new assignment?

if (ps != null) ps.close();
ps = connection.prepareCall(<some query>);

I suspect that you use connection pooling, so your releaseConnection()
does not actually close it. Therefore you loose approx. 4 statement
handles in each execution. Approx. at 5,000 executions FB runs out
statement handles.

Best regards,
Roman Rokytskyy



To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.