Re: persistent database problem

[Differentiated Software Solutions Pvt. Ltd]

Hi,

To avoid this problem, we specifically started only one httpd.

Murali

Differentiated Software Solutions Pvt. Ltd.
176, Ground Floor, 6th Main,
2nd Block, RT Nagar
Bangalore - 560032
Phone : 91 80 3431470
www.diffs-india.com
----- Original Message -----
From: John K. Sterling <[EMAIL PROTECTED]>
To: Differentiated Software Solutions Pvt. Ltd <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, October 23, 2000 1:35 PM
Subject: Re: persistent database problem


>
> The db connection happens once for each child - so every time you hit a
> child for the first time it will open up a new connection - you probably
> have apache configured to start with 4 or so kids.
>
> sterling
>
>  On Mon, 23 Oct 2000,
> Differentiated Software Solutions Pvt. Ltd wrote:
>
> > Hi,
> >     I have started with one httpd; and executed the following mod-perl
program from the browser. We've configured apache to have persistent DBI
> >     The idea is first time the database handle will be inactive and it
will print 'INSIDE'.  From the second time onwards the database handle will
be active and it will print 'OUTSIDE'.  This is working.
> >     But, sometimes the 'OUTSIDE' comes from the third or fourth time
only.  (that is it takes more than one attempt to become persistent) Why it
is happening like this?
> > Thanks
> > Muthu S Ganesh
> >
> > mod-perl code is here:
> >
> > $rc = $dbh_pg->{Active};
> > print "$$: $rc\n";
> > if($rc eq '')
> > {
> >         print "INSIDE\n";
> >         $dbh_pg =
DBI->connect("dbi:Pg:dbname=adcept_smg_ctrl","postgres","postgres",{RaiseErr
or => 1}) || die $DBI::errstr;
> > }
> > else
> > {
> >         print "OUTSIDE\n";
> > }
> >
> >
> > Differentiated Software Solutions Pvt. Ltd.
> > 176, Ground Floor, 6th Main,
> > 2nd Block, RT Nagar
> > Bangalore - 560032
> > Phone : 91 80 3431470
> > www.diffs-india.com
> >
>