[Zope-DB] Two actions in one ZSQL method = one transaction?
ken at sunward.org
Thu Jun 14 10:50:21 EDT 2007
Great! Thanks again.
> -----Original Message-----
> From: Andreas Jung [mailto:lists at zopyx.com]
> Sent: Thursday, June 14, 2007 10:48 AM
> To: Ken Winter; 'Andreas Jung'; 'Zope-DB List'
> Subject: RE: [Zope-DB] Two actions in one ZSQL method = one transaction?
> --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
> > ...
> >> > Does a ZSQL method initiate a database transaction,
> >> so
> >> > that no other user can inset another record between the two actions
> >> > 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
> >> 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*
More information about the Zope-DB