Have you tried running your application for a long time without Tomcat? That
is, are you sure the problem is Tomcat related. Specifically, we found the
the Oracle JDBC drivers have a memory leak such that if you don't explicitly
close the Statements the connection will keep a reference to them and
allocate more and more memory.
--Rainer
> -----Original Message-----
> From: Dan Randall [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, May 05, 2001 3:32 AM
> To: [EMAIL PROTECTED]
> Subject: Loosing Connections in a pool
>
>
> Hi,
>
> My tomcat application runs in a production environment for about
> 24 hours before it fails and must be restarted. During that time
> JDBC connections to Oracle become ignored and eventually
> disappear. A fair guess is that I am loosing memory, threads and
> resources in general until there is nothing left and only a
> restart cures the matter.
>
> Unfortunately, tomcat, rather than apache is serving much of the
> pages and graphics. That may be a contributing factor?
>
> I am using:
>
> Solaris 8
> Oracle 8.1.7
> tomcat 3.2.1
> apache 1.3.19
> and Java 1.3
>
> Does anyone have an idea of what sort of problems I might be
> having? Any known resource leaks or threading issues?
>
> Thanks!!
>
> Dan
>