[Zope-DB] [SOLVED]: ZSQL meyhod fr an Oracle Stored Procedure
that Returns a ref_cur
wlang at wu-wien.ac.at
Mon Nov 19 07:22:39 EST 2007
According to banaouas:
> > If you are writing to a transactional database, you should add
> > conn._register()
> > to register that connection for the zope transaction
> > machinery. That way the Zope Publisher calls "commit" at the end of a
> > successful request (or "abort" on error).
> Initially, I needed to access to this oracle database only for read
> But even for read only access, it might be a good practice to add this
> commit, cause sometime database engins hold some kind of lock on the read
> data, depending on how transaction was started.
It might be a good practice, because you never know, if your
application will eventually also be writing to the DB. I don't know if
it has an effect on read only operations.
> I imagine that zsql class do implicitely this commit ?
Strictly speaking its no "commit", its a "registration for
commit/abort". And yes, for ZSQL methods this is done implicitly (via
the "query" method of the DB class).
Willi.Langenberger at wu-wien.ac.at Fax: +43/1/31336/9207
Zentrum fuer Informatikdienste, Wirtschaftsuniversitaet Wien, Austria
More information about the Zope-DB