[Zope] Transactions support on MySql

CHUNG-SHU YANG luckyang@lion.syscom.com.tw
Mon, 27 Sep 1999 09:42:18 +0800


Hi,

So how about databases supporting transaction controls?

How can I do database transaction controls(set autocommit on/off, commit
transaction, etc) myself?

CS


-----Original Message-----
From: Evan Simpson <evan@4-am.com>
To: pinglau@theoffice.net <pinglau@theoffice.net>
Cc: zope@zope.org <zope@zope.org>; zope-dev@zope.org <zope-dev@zope.org>
Date: Monday, September 27, 1999 2:07 AM
Subject: [Zope] Re: [Zope-dev] Transactions support on MySql


>Ping Lau wrote:
>
>> 1. From what I read, Zope supports transactions.  If I
>> want to use MySql as my backend database, can Zope
>> still support atomic operations since MySql does not
>> support transactions?
>
>Zope will still support transactions on *Zope objects*.  Your MySQL
>database will not participate in the transaction, so all SQL statements
>executed will remain in effect even if the Zope transaction aborts.
>You might be able to handle this with explicit logging in MySQL, if the
>changes aren't too complicated.
>