Hi Floyd, Floyd May wrote: >> Like Michael, I had understood that ZSQL database transactions were tied >> into Zope transactions, and would fail or succeed as a whole. Like him, >> I have found that - at least with this combination of DA & RDBMS - this >> is not so. I work around it, as I always do when a Microsoft product is >> involved. If I hit the same thing with PostgreSQL, I'll look into it >> deeper... > > I was under the impression that ZSQL methods were very much intended to > be atomic: > http://www.plope.com/Books/2_7Edition/RelationalDatabases.stx#2-77 >
Yes, the docs seem pretty unambiguous. > I know that it's been atomic to the point of frustration when working > with Zope and MySQL. Perhaps the database adapter is at fault here? > Surely there /is/ only one point to which it can be atomic? ;-) There are several layers to this - the eGenix DA, the eGenix ODBC stuff below that, MS's ODBC driver for SQL Server and SQL server itself. If I hit the issue with the eGenix DA and another (non-MS) database, or with another DA and another (non-MS) database entirely, I would spend time trying to diagnose it. Having wasted a big chunk of my life on troubleshooting this stuff I now have a rigid policy - if an MS product is involved I want to know how it /does/ work and develop against that, otherwise I want to know how it /should/ work and make sure it does. I'm not trying to denigrate MS (I earn a living on Windows, can live with the OS, can live without the applications), I'm just making an observation on not throwing precious time away on things that are unfathomable. -- Regards, PhilK Email: [EMAIL PROTECTED] PGP Public key: http://www.xfr.co.uk Voicemail & Facsimile: 07092 070518 “The creative impulse animates whatever instrument is placed at its disposal.” — Robert Fripp _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
