[Zope-DB] ZODBC Information

Dieter Maurer dieter@handshake.de
Fri, 19 Jul 2002 21:26:45 +0200


Jose Gerardo Amaya Giron writes:
 > >  > 1.- Does the ZODBC support MS SQL Server transactions? How?
 > > Almost surely. And automatically. You need to do nothing.
 > Thanks for the reply and sorry for my newbie question but I need to ask
 > this.
 > 
 > By automatically you mean that the ZODBC support transactions, not that
 > ZODBC automatically creates a transaction for every query(method) you
 > use.
I am not sure, but I expect it.

   No senseful person should put a connection used by Zope
   in auto-commit mode, when the underlaying database
   supports explicit transactions.

As ZODBCDA war developed by Zope.com, I am almost sure, they
did not do that.


 > You see the problem is not mine, one of our programmers develop a
 > website with multiple SQL Methods, but he never use transactions and now
 > we have kind of a problem. He asume that Zope create transaction and
 > rollback if necesary, so we are all trying to find a solution that
 > causes less damage to the hole development.
He is right.


Dieter