[Zope-DB] [Zope] ZSQL Methods and transaction control

[robert rottermann]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Charlie Clark schrieb:
> Am 10.01.2007, 13:16 Uhr, schrieb robert rottermann <robert at redcor.ch>:
> 
>> thanks charlie,
>> so that means, that the _commit and _abort methods are only for zope's
>> transaction controll.
> 
> Yes, and with good reason.
> 
>> do you have a suggestion how then to start/commit a transaction from
>> within a ZSQL method (or ZMySQLdb)
> 
> Well, if you check last week's archives, you'll notice a very similar
> question came up. We suggest using the our mxODBC ZopeDA with an
> ExternalMethod for this kind of thing as it gives you a lot more control
> and allows you to work outside the restrictions on ZSQL which, good as
> it is, isn't suitable for this.
> 
> Charlie
> 
> 
thanks for your suggestion.
i am using mxODBC for 2 cusomers and I was under the impression, that it
is used (as the name suggests) to connect to a odbc database.
would using it mean that I had to access MySQL trough odbc. or does
mxODBC know how to access MySQL ?

thanks
robert
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFFpQ2aGaryJ0T9kUYRAirQAJ9e0ZT9EWubdUnywMX+dLZ2+u6OHwCdE2/z
1DJB8m6UhxqjQgl4s4JhpXA=
=JZPn
-----END PGP SIGNATURE-----