> > Your script uses an END block to disconnect. If you use
> > Apache::Registry, that will not be run until the server is shut down.
> > With Apache::DBI, you should get one connection per Apache process, and
> > they'll stay open. If you are changing the login parameters (i.e.
> > different us
> > Your script uses an END block to disconnect. If you use
> > Apache::Registry, that will not be run until the server is shut down.
> > With Apache::DBI, you should get one connection per Apache process, and
> > they'll stay open. If you are changing the login parameters (i.e.
> > different us
> "DJ (David J Radunz)" wrote:
> I am having a problem with a module im writing connecting to the
> database everytime its run, and not cleaning up the database
> connection when its finished.
Your script uses an END block to disconnect. If you use
Apache::Registry, that will not be run unti
Hi there,
On Thu, 13 Sep 2001, DJ (David J Radunz) wrote:
> the database connections just keep building up.
Read the database section of the Guide:
http://perl.apache.org/guide
73,
Ged.
On Thu, 13 Sep 2001, DJ (David J Radunz) wrote:
> use strict;
> use vars ($dbh);
You don't need this with Apache::DBI. Globals in general should be
avoided/used with extreme caution.
> use mod_perl;
Don't need this either.
> 1;
> END {
> $dbh->disconnect;
> }
Put this before the '1;'
