Re: Transaction Wrapper and Perl 5.6.1

[prev] [thread] [next] [Date index for 2004/09/02]

> I'm trying to implement a custom trasaction subroutine in my program and I
> found out that "local $class->db_Main->{AutoCommit};" inside of
> do_transaction() subroutine caused memory leaks with Perl 5.6.1 from
> www.class-dbi.com site.
>
> Unfortunately, I'm using Perl 5.6.1 and trying to find the way to solve
> this issue without upgrading Perl.
>
> Does anybody know how to solve this issue or what causes memory leaks?

I'm kind of locked into Perl 5.6.1 myself. My solution is to add
AutoCommit => 1 to all of my Class::DBI connection attributes. If you're
always in AutoCommit mode, then you don't need to "local
$class->db_Main->{AutoCommit};" in the do_transaction() method (just comment
that line out) and you won't leak memory.

Hope this helps,
Ed