Has anyone had much experience with using the new transactions features of MySQL with DBI and DBD::mysql?

Our initial experiments with them show that the latest DBD::mysql driver (version 2.0415) doesn't permit the use of transaction by virtue of the fact that the Autocommit flag insists on remaining on, which of course, obviates the concept of transaction.

what can be done to get around this though, is to use the (rather crude) do method: 

 $dbh->do('begin');  
 $dbh->do('commit');
 $dbh->do('rollback');

[download]

This works, but probably isn't portable and probably isn't the 'right' way to do things. does anyone else has advice/experiences to offer?

d_i_r_t_y

In reply to DBI and transactions on MySQL by d_i_r_t_y

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.