[Zope-DB] DCOracle2 and multiple SQl statements
Matthew T. Kromer
matt@zope.com
Wed, 30 Jan 2002 10:13:39 -0500
Smith, Neil wrote:
>I've just noticed with horror that when a sql method was called that had
>multiple sql statements (separated by <dtml-var sql_delimiter>) and one of
>them failed, the preceding statements have been committed. I was under the
>impression that the whole thing should be rolled back. Is that not how it
>is supposed to work?
>
>I'm using Zope 2.4.3 binary release on Windows NT 4 and DCOracle2-pre1.
>
Thats what is supposed to happen, yes. Unless you call something that
explicitly does a commit() there shouldn't be any problem with issuing
multiple statements in the same transaction.