[Ape] APE leaving SQL transactions open

[Paolo Bizzarri]

Hi all.

Sorry for the cross-posting between this and zope-dev: we discovered ape 
mailing list after sent the first message.


We're making our first experiments with APE. The environment is Zope 2.7.1 on 
Linux. We're using APE 0.8.1.

A problem we encountered is that APE leaves the final db transaction neither 
commited nor aborted, in the normal behaviour.

I mean, this is what is going on here:

1) I create a new object under the /sql folder
2) all the required SQL transaction is done, and data is commited on the DB
3) a new SQL transaction begins (corresponding to the new zope transaction) 
for the new page

but this last SQL transaction is never closed.

The short story is that you can see the (in)famous "idle in transaction" 
message on a ps axf on the box

Since we had very bad experience with the "idle in transaction" in the past, 
we would like to know if this is a known behaviour, if it is safe, and why.

Thank you all.

Regards
Paolo

-- 
Paolo Bizzarri - President - Icube S.r.l.
Address:   	Via Ridolfi 15 - 56124 Pisa (PI), Italy
E-mail:	p.bizzarri at icube.it	Web:	http://www.icube.it
Phone:	(+39) 050 97 02 07	Fax: 	(+39) 050 31 36 588