[Dbix-class] ROLLBACK seems to be skipped on 0.08

[Matt S Trout]

On Thu, Nov 01, 2007 at 05:55:14PM -0700, Louis Erickson wrote:
> 
> Sorry to wake up a slightly old thread, but I've just been bit by this in 
> an 0.07 to 0.08 upgrade, and found this thread.  (This bit me as soon as I 
> started using 0.08.  I just started using it or I'd have asked earlier.)
> 
> One difference between what I'm reading here and what I'm seeing in my own 
> app is that I always do a txn_begin/txn_commit, and it does not work as 
> I'd expect, either.
> 
> (It starts at a transaction level of 1, which is incremented by the begin, 
> and decremented by the commit, so that it never actually commits to the 
> DB.  To either comment out the begin or add an extra commit works around 
> it, despite being extremely goofy looking.)

That's basically DBIC being 'more correct' now.

AutoCommit 1 says to DBI "I want to always be within a transaction".

Therefore you need to commit that implicitly started transaction to get an
actual commit.

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director                    http://www.shadowcat.co.uk/catalyst/
 Shadowcat Systems Ltd.  Want a managed development or deployment platform?
http://chainsawblues.vox.com/            http://www.shadowcat.co.uk/servers/