> -----Original Message-----
> From: Tamas [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 10, 2000 7:03 AM
> To: mod perl
> Subject: ApacheDBI persistant connections
>
>
> I have a problem with persistant connections from my PerlAuthHandler.
>
> If you request a page, then I get 2 persistant connections to the
> database. The quickly become sleeping connections. Fine so far.
> Wait around 30 seconds and then refresh the page. And get another
> 2 sleeping connections. Obviously something is not right.
Apache::DBI caches connections per-connect string and per apache child -
thus
if you have 5 children and each foo.pl connects to two databases, you
eventually will get
10 database connections...
sounds like you are hitting another apache child with the refresh - try
httpd -X if you are still unsure...
>
> Could it be anything to with the versions of the DBD, DBI, Webserver,
> mod_perl? If not, and it is just me being awful, how do I disconnect
> those pesky connections?
>
> I have a DESTROY function that I call ( $self->{dbh}->disconnect ),
> but that doesn't appear to make any difference.
no need to worry about that, disconnect() is a no-op under Apache::DBI...
HTH
--Geoff
>
> Thanks for any help,
>
> Tom
>
