>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 7/4/00, 12:47:07 AM, Andy Dustman <[EMAIL PROTECTED]> wrote regarding
Re: [Zope] MySQL transaction support (was: MySQL S
On Tue, 4 Jul 2000, Hannu Krosing wrote:
> AFAIK the transaction support is enabled on table-by-table basis, so
> there
> is no way to know for sure if transactions are
> supported/partially-supported/unsupported for a particular set of
> queries
True enough. There are several problems here:
Andy Dustman wrote:
>
> There are two factors which determine whether or not transactions can be
> supported. Actually, there's only one, but it can't be directly tested
> for:
>
> 1) If the server version (easily obtained upon establishing the
> connection) is < 3.23.15, transactions are defini
On Mon, 3 Jul 2000, Monty Taylor wrote:
> Why not have one ZmySQLDA that attempts to determine whether it is
> transactional or not when the connect method is executed. That way you
> could have a DA connect to your 3.22 database, upgrade your database to
> >3.23.15 and not see any problems. A
Why not have one ZmySQLDA that attempts to determine whether it is
transactional or not when the connect method is executed. That way you
could have a DA connect to your 3.22 database, upgrade your database to
>3.23.15 and not see any problems. A combination of try-except:ing an
attempted "beg
> -Original Message-
> From: Andy Dustman [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 30, 2000 4:08 PM
> To: Ron Bickers
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: [Zope] MySQL transaction support (was: MySQL Select
> Statements)
> with B
On Fri, 30 Jun 2000, Ron Bickers wrote:
> > That's the problem: They don't get control over when BEGIN/COMMIT/ROLLBACK
> > are used. Zope does that if you are using the Transaction Manager. And the
> > only way to control use of the Transaction Manager is by
> > selection of DA.
> >
> > That's wh
> -Original Message-
> From: Andy Dustman [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 30, 2000 1:25 PM
> To: Ron Bickers
> Cc: Michael Blewett; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: [Zope] MySQL Select Statements
> That's the problem: They don't get control over when BEG