[DB-SIG] Transaction start

zammon@libero.it zammon@libero.it
Sat, 25 May 2002 08:04:49 +0200

Gerhard H=E4ring wrote:

>The DB-API Connection object has commit and rollback methods, but it
>lacks a begin method.
the begin transaction is not a standard SQL command,  but some databases=20
implement such command.
to have two kind of functionality with and without transactions,
infact a database don't need  a command like this if it works all the=20
time under transactions.
I suppose DBI  works in this way.

>Not considering the implementation of an autocommit feature, does this
>mean that the DB-API module must implicitely start, and possibly roll
>back transactions at certain points?
>I guess a cursor.execute must start a new transaction, where else must a
>transaction be started? Could anybody please clarify this?