perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vincent Veyron <vv.li...@wanadoo.fr>
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 <pharkins@gmail.com> 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

https://marica.fr/
Gestion des contentieux, des dossiers de sinistres assurance et des contrats pour le service
juridique

Mime
View raw message