>-----Original Message-----
>From: Jonathan Leffler [mailto:[EMAIL PROTECTED]]
>Neil Lunn wrote:
>
>> It's off by defualt. But the documentation should help more here.
>
>Are you sure? I think you'll find it is on by default,
>because that's the only
>mode that all databases, even databases without transactions
>(eg DBD::CSV,
>unlogged Informix databases, older versions of MySQL, etc),
>can support.
Yes, usually this is the case but not *all* databases support transactions.
I was thinking that there was an issue where the ODBC spec had transactions
off by default and that was followed by DBI. In fact from the documentation:
Drivers should always default to "AutoCommit" mode (an
unfortunate choice largely forced on the DBI by ODBC
and JDBC conventions.)
So are any drivers not doing this? I always explicitly set AutoCommit => 0
when I want transactions enforced.
--Neil
__________________________________________________________________________
Please Note :
Only the intended recipient is authorised to access or use this e-mail.
If you are not the intended recipient, please delete this e-mail and notify
the sender immediately. The contents of this e-mail are the writer's
opinion and are not necessarily endorsed by the Gunz Companies
unless expressly stated.
We use virus scanning software but exclude all liability for viruses or
similar in any attachment.
