[Zope3-dev] Database Transaction Handling

Axel Missbach Axel.Missbach@t-online.de
Thu, 24 Oct 2002 10:52:14 +0200


Hello,

in my opinion a great handicap of zope2 is occuping the 
database-transaction for the kommunikation  of documents and extern 
databases(i.e. postgres).

	implicit start transaction to database
	opening document
	.
	.
	.
	close document
	implicit commit/close transaction to database

There is no transaction left to handle the querys/ data of the database.

What about of explizit using the transaction handling by the user/developer?
Isn't it possible to create an zope intern transaction handling without 
interacting with the database? Implementing something like 
triggers/events for documents, so having the possibility to change the 
default behavior?
i'd like to handle the database transaction like this:

	opening document
	sql_query starts transaction
	sql_query gets data
	doing something
	.
	deciding if commit or rollback the querys
	closing document
	
Axel