[Zope-DB] ZODBC Information
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
> By automatically you mean that the ZODBC support transactions, not that
> ZODBC automatically creates a transaction for every query(method) you
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.