[CDBI] Ima::DBI with Class::DBI question
Carlos Vicente <cvicente-zZ82ZiX1S8l+u43qRgrggVnYRNhDb3e+9nwVQlTi/[email protected]> Fri, 27 Mar 2009 11:20:58 -0700
| Newsgroups | gmane.comp.lang.perl.modules.class-dbi |
|---|---|
| Message-ID | <[email protected]> |
Hi all,
I'm a bit confused by the part of Ima::DBI's documentation that talks
about adding something like:
$r->push_handlers(PerlCleanupHandler => sub {
MyImaDBI->rollback();
});
in mod_perl environments in order to preserve a functionality covered by Apache::DBI.
Is this necessary when using Ima::DBI via Class::DBI? After adding this (in my Mason handler), I started seeing these errors in my Apache logs:
DBD::mysql::db rollback failed: Rollback ineffective while AutoCommit is on at /usr/lib/perl5/site_perl/5.8.8/Ima/DBI.pm line 596
I suppose it has to do with the fact that AutoCommit is on by default with Class::DBI (and I want it that way).
What's the suggested setup in this case?
Thanks in advance,
cv