[Zope-DB] Two actions in one ZSQL method = one transaction?
lists at zopyx.com
Thu Jun 14 10:48:17 EDT 2007
--On 14. Juni 2007 10:41:46 -0400 Ken Winter <ken at sunward.org> wrote:
>> -----Original Message-----
>> From: Andreas Jung [mailto:lists at zopyx.com]
>> Sent: Thursday, June 14, 2007 12:54 AM
>> To: Ken Winter; 'Zope-DB List'
>> Subject: Re: [Zope-DB] Two actions in one ZSQL method = one transaction?
>> > Does a ZSQL method initiate a database transaction,
>> > that no other user can inset another record between the two actions in
>> > this ZSQL method?
>> *If* you database provides
>> transaction support and *if* your DA integrates with the transaction of
>> *then* everything happening within one Zope request will happen within
>> one Zope transaction and therefore within one DB transaction. This isn't
>> necessarily true to databases like MySQL.
> My database is PostgreSQL 8.x and my adapter is ZPsyocopgDA. Does this
> combination provide the transaction support you're talking about?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 186 bytes
Desc: not available
Url : http://mail.zope.org/pipermail/zope-db/attachments/20070614/d9deb043/attachment-0001.bin
More information about the Zope-DB