[Zope-DB] Problems with transaction management and many database adapters

[M.-A. Lemburg]

Marco Bizzarri wrote:
> First of all, thanks for your reply. After a few research, we discover 
> the problem caused by our example. As you may remember, there was a page 
> template, using a dtml (standard_html_header), calling a PT 
> (menu_headers), calling a SQLMethod.
> 
> As you can see running the example and getting a look at the logs, 
> viewing the PT index_html causes two transactions to be opened: the 
> first one ends with a commit, the second one remains open (no commit or 
> rollback), which is strange since every zope transaction 
> (request/respose) should be the boundary also of a database transaction 
> (either begin/commit or begin/rollback).
> 
> The problem is in the paflow.js javascript file, which is in the 
> standard_html_header. The browser, behind the scene, after getting the 
> index_html, tries to get the paflow.js. However, since this is not 
> present, it raises a resource not found error, and sends back to the 
> browser an error page (which is not shown to the user, since this error 
> is silently captured by the browser). The error produces a 
> standard_error_message page, which, by default, includes the 
> standard_html_header, which calls the menu_html which calls the SQL 
> Method (oh gawd!). Here is either the feature or the strange behaviour: 
> this is the second transaction which is not closed (no commit/rollback 
> at the end). Is this a known behaviour? Or is there something we are 
> missing?

Hmm, sounds like something is going wrong in Zope for the special case
of error handling.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Feb 03 2004)
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
2004-01-23: Released mxODBC.Zope.DA 1.0.8        http://zope.egenix.com/

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::