in reply to odd transaction behavior: dbi mysql

Threading? AutoCommit?
  • Comment on Re: odd transaction behavior: dbi mysql

Replies are listed 'Best First'.
Re^2: odd transaction behavior: dbi mysql
by nmerriweather (Friar) on Oct 21, 2005 at 01:05 UTC
    That was it - AutoCommit.

    I'm new to this, so hopefully someone can enlighten me:
    I set AutoCommit to 0 - it turns out that AutoCommit must be 1 in order to handle begin_work

    Is there any way to enforce all code happen within a begin / ( commit/rollback) bookends? It seems that with AutoCommit 0, there is no way to begin; and with autocommit 1 there is no way to force code to happen without an explicit transaction declaration.
[reply]

In Section Seekers of Perl Wisdom