[Zope-DB] Questions on DAs and TAs
Martin Gebert
Murphy@members.netsolution-net.de
Wed, 11 Sep 2002 11:48:31 +0200
Hi all!
For further work on Zope and DB connectivity I'd like to ask some
questions which I need to clarify. I beg your pardon if they've been
asked and answered already; hints for ressources are very welcome.
- Are there developers documents on DAs, esp. API references? I found
two docs of petrilli (Roadmap for Zope Database Adapters
<http://www.zope.org/Members/petrilli/DARoadmap> and How to Write a DA
<http://www.zope.org/Members/petrilli/WritingADA>) which should give me
the basics, but they seem to be a little outdated (from 1999/2000), so I
wonder if there are more ressources on this subject?
- As I understand from reading some relevant postings in the archives of
this list, RDBMS transactions in Zope are bound to the Zope TA concept,
where TAs start and end with building a DTML document (correct/put too
simple?). Are there any possibilities to force TA management by
commit/rollback actions via the DA? (How) Can I manually rollback if
something in a script fails? The ZopeBook says less more than nothing
about that subject... :-(
- Did I get it right that (explicit) locking has to happen in Z SQL
Methods? Having experience with Oracle locking mechanisms only, I wonder
if that offers independence from different DBMS's (e. g. migrating a DB
from, say, Oracle to MySQL, and having to change the Z SQL Methods due
to different locking paradigms instead of simply setting up a new DA;
hope you can follow what I try to express...). Are there no methods for
locking in the DA API?
Thank you for reading; all hints on this subject are very welcome.
Probably more questions to come...
Martin