Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked

Re: Re: Re: DBI recipes

by mpeppler (Vicar)
on Aug 18, 2003 at 10:04 UTC ( #284525=note: print w/ replies, xml ) Need Help??

in reply to Re: Re: DBI recipes
in thread DBI recipes

When transactions are supported, while it is true that every update BELONGS TO a transaction, it is not true that every insertion IS a transaction.
I'm nitpicking, but with Oracle, DB2, Sybase, etc. every DML operation is run in a transaction. The transaction may automatically commit at the end of the operation (i.e. if AutoCommit is on), but there is always at least an implicit transaction as even a single row insert may in fact generate more operations through triggers (inserts to a shadow table, updates of summary tables, etc.) and these all will be guaranteed to perform as a single operation, even in the absence of explicit transactions in the DML.

That being said I think that keeping the transaction logic out of the examples is a good thing, as long as their use and functionality is explained somewhere in the document - after all transactions are pretty central to RDBMS systems...


Comment on Re: Re: Re: DBI recipes

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (7)
As of 2015-11-28 16:45 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (743 votes), past polls