[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