Thanks for the input ikegami, much appreciated - I will be making some changes as a result...

Re: "I don't see the point of determining the capability in advance", that depends on whether "it's a bug to call call the same code_that_touches_db() whether transactions are available or not":

I'm working under the assumption that if a user has a DB that is not transaction-capable (not sure what DBs those might be these days...) that they may decide to proceed at their own risk, assuming the risks are clearly laid out in the documentation. If that's the case, then there's a benefit to checking one time in the constructor, so I don't have to do any extra work while attempting (possibly many) transactions later on.

Not entirely sure if that is the best approach... Maybe I could have the constructor die() if transactions are not possible, unless the user supplies a "no_transactions_are_ok" parameter...

In reply to Re^2: How to safely test if a database handle is capable of transactions? by larryl
in thread How to safely test if a database handle is capable of transactions? by larryl

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.