I'm using mod_perl and have Apache::DBI in my startup.pl file.

I usually put my DBI->connect line outside of the handler sub... however, I
would like to put the DBI->connect line inside of the sub so I can get the
connection info from a couple of 'PerlSetVar' config directives (similar to
the way edmund mergl does in AuthDBI).

I'm concerned that if I do this without calling disconnect(), I will end up
with a whole bunch of open connections to my DB.  Am I correct in assuming
this?  If so, what's a better way to move the call to connect() outside of
the handler subroutine while still having the ability to use PerlSetVar
config directives to get args for connect()?

Ian

Reply via email to