Re: [Zope] Transactions support on MySql
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.
CHUNG-SHU YANG wrote:
So how about databases supporting transaction controls?
The Zope DA (Database Adapter) for the database you choose has to be support transactions -- check the DA list at zope.org
How can I do database transaction controls(set autocommit on/off, commit transaction, etc) myself?
A correctly written DA will start a transaction when the database is first touched, then commit or rollback along with the request.
participants (2)
-
CHUNG-SHU YANG -
Evan Simpson