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