[DB-SIG] looking for transaction documentations

Federico Di Gregorio fog@mixadlive.com
10 Dec 2001 11:48:28 +0100


On Sat, 2001-12-08 at 02:17, Bob Kline wrote:
> On Fri, 7 Dec 2001, Wichert Akkerman wrote:
>=20
> > I can't seem to find in the DB API 2.0 spec how to transactions. The
> > text does mention them, but it is silent on how to start, abort or
> > end them.
> >
> > Can someone shed some light on this?
>=20
> Sure.  This API follows the ANSI SQL standard in its approach to
> transactions, which are always implicit.  Look at the docs for commit()
> and rollback().  Think of it as working in a world where 'autocommit' is
> always off.

just noting that at least half of the db adapters out there offer an
autocommit mode where you can roll your own transactions sending
"BEGIN", "COMMIT", etc. queries.

--=20
Federico Di Gregorio
Debian GNU/Linux Developer & Italian Press Contact        fog@debian.org
INIT.D Developer                                           fog@initd.org
  Qu'est ce que la folie? Juste un sentiment de libert=E9 si
   fort qu'on en oublie ce qui nous rattache au monde... -- J. de Loctra