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.