Re: persistent database problem

[Differentiated Software Solutions Pvt. Ltd]

Yes
----- Original Message -----
From: Jeff Beard <[EMAIL PROTECTED]>
To: Differentiated Software Solutions Pvt. Ltd <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, October 23, 2000 7:08 PM
Subject: Re: persistent database problem


> Are using Apache::DBI and establishing a connection in
> your startup.pl?
>
> 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
> >
>
> --
> Jeff Beard
> ___________________________________
> Web:        www.cyberxape.com
> Location:   Boulder, CO, USA
>
>