Do you use a connection pool or do you have connections open for several hours ? Most databases have a maximal time frame for an open connection. So your software (or the connection pool you're using) has to be prepared to reconnect if the server closes the connection. > -----Ursprüngliche Nachricht----- > Von: Dan Randall [mailto:[EMAIL PROTECTED]] > Gesendet: Freitag, 4. Mai 2001 20:32 > An: [EMAIL PROTECTED] > Betreff: 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 > >
