[Zope-DB] Two actions in one ZSQL method = one transaction?

Andreas Jung 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,
>> so
>> > 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
>> Zope
>> *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.
>>
>> -aj
>
> My database is PostgreSQL 8.x and my adapter is ZPsyocopgDA.  Does this
> combination provide the transaction support you're talking about?
>

*Of course*

-aj
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
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 mailing list