Re: [Zope] ZSQL Methods and transaction control
robert rottermann <[email protected]>
| Newsgroups | gmane.comp.web.zope.database |
|---|---|
| Message-ID | <[email protected]> |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Charlie Clark schrieb: > Am 10.01.2007, 13:16 Uhr, schrieb robert rottermann <[email protected]>: > >> 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-----