perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vincent Veyron <>
Subject Re: Disconnect database connection after idle timeout
Date Fri, 14 Nov 2014 18:54:48 GMT
On Fri, 14 Nov 2014 08:30:18 -0500
Perrin Harkins <> wrote:

> If you ever switch off AutoCommit in
> your code, I'd suggest adding a cleanup handler that checks if the handle
> is not currently in AutoCommit mode, and if not, issues a rollback and
> switches it to AutoCommit. That protects against an exception leaving your
> database handle in a bad state. (Apache::DBI tries to do that
> automatically, but it's not very smart about it. It only happens if you
> have AutoCommit off when you connect.)

Ha yes, I see some threads about this. Thanks for the heads up.

					Salutations, Vincent Veyron
Gestion des contentieux, des dossiers de sinistres assurance et des contrats pour le service

View raw message