Re: Disconnect database connection after idle timeout
Vincent Veyron <[email protected]>
| Newsgroups | gmane.comp.apache.mod-perl |
|---|---|
| Message-ID | <[email protected]> |
On Fri, 14 Nov 2014 08:30:18 -0500 Perrin Harkins <[email protected]> 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