RE: [Zope] ZOracle SP does not commit ?
Dieter, self._register() gets called from __call__(self, *args, **kw),
-----Original Message----- From: Dieter Maurer [mailto:dieter@handshake.de] Sent: Saturday, August 25, 2001 12:05 AM To: Ernst Eeldert Cc: 'zope@zope.org' Subject: Re: [Zope] ZOracle SP does not commit ?
Ernst Eeldert writes:
when I use the Z Oracle Stored Procedure object to execute a package procedure which inserts stuff into the database, the transaction does not get committed. I use a Python Script to execute the SP.
I checked the source code of the ZOracle SP, and it seems that the commit gets done in the _finish() method. How can I tell if this method is called ? It's called automatically when the request finished successfully (in "ZPublisher.publish") provided that the stored procedure registers itself with Zope's transaction subsystem (something like "self._register"). Registration may have been forgotten...
Dieter
Ernst Eeldert writes:
self._register() gets called from __call__(self, *args, **kw), That means, Oracle should get either a "commit" or "abort" at the end of the request...
In exceptional cases, there may be a whole in the transaction system (reported to the list a few month ago, probably a "Collector" entry). But usually, it should work... Dieter
participants (2)
-
Dieter Maurer -
Ernst Eeldert