Quoting Michael Peters <[EMAIL PROTECTED]>: > Tobias Kremer wrote: > > use vars qw( $dbh $thefoo ); > Why are you storing the DB handle in a global variable? > If you do that then Apache::DBI can't help you if the connection goes away.
To make this variable available to all Mason components. Theoretically, this shouldn't be a problem because I'm (re-)connecting on every request in the handler() subroutine not once during startup. Actually it works perfectly as soon as you remove the one-time connection made during startup (LostFoo) which just preloads some data from the database. According to the docs Apache::DBI should automatically avoid caching this connection. --Tobias
