Ok. I have a class called QuizData which maintains all database
connections. An instance of this class is created by a servlet each time
it runs the doGet() method. In the finalize method of the QuizData
class, I have something like:

        if (isOpen()) {
                db.close;
        }

isOpen() returns the value of a instance variable of type boolean in the
object (QuizData) when the database is successfully opened.

How does that sound? Anything else needed so far?

> At 16:55 +0300 on 13/07/1999, PAUL J THOMPSON wrote:
> > I'm sorry, but I believe you I misconveyed my dilemma. It is postgres
> > which is running away with too many processes - not Apache. What would
> > lowering MinSpareServers (etc) do to help that?
> 
> Let's try to attack this problem: Where do you keep your connection objects
> in the servlet? Instance variables in the servlet class? Local variables in
> one of the methods? The session object?
> 
> Herouth
> 
> --
> Herouth Maoz, Internet developer.
> Open University of Israel - Telem project
> http://telem.openu.ac.il/~herutma

-- 

-paul
<[EMAIL PROTECTED]>

/*
 * Go to http://www.geekcode.com for interpretation:
 *
 *  -----BEGIN GEEK CODE BLOCK-----
 *  Version: 3.1.2
 *  GCS/MU/S/U/O d++(-) s:- a-- C+(++) UL++++$ P+ L+++@ E(---) W++
 *  N o+ K- w--(---) !O M V-- PS-- PE Y PGP>+ t++@ 5 X+ R-- tv+(tv)
 *  b+>+++ DI+++ D--(-) G e>++ h--- r+++ y?
 *  ------END GEEK CODE BLOCK------
 */

Reply via email to