Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re^2: How to safely test if a database handle is capable of transactions?

by larryl (Scribe)
on Nov 19, 2008 at 17:04 UTC ( #724649=note: print w/ replies, xml ) Need Help??


in reply to Re: How to safely test if a database handle is capable of transactions?
in thread How to safely test if a database handle is capable of transactions?

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...


Comment on Re^2: How to safely test if a database handle is capable of transactions?

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://724649]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (10)
As of 2014-08-28 09:44 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (259 votes), past polls