What I want from connection pooling is to cache database connections for a relatively short period of time, such as while a user is actively clicking around a web application. Once that user leaves the application, ideally the database connections would expire.
You might have better success by simply changing the session inactivity timeout on your database server. This would require no changes to Apache::DBI, and avoids the drawbacks you mentioned at the end. If someone comes in and tries to use a timed out connection, Apache::DBI will just reconnect.
- Perrin
-- Report problems: http://perl.apache.org/bugs/ Mail list info: http://perl.apache.org/maillist/modperl.html List etiquette: http://perl.apache.org/maillist/email-etiquette.html
