On Apr 24, 2007, at 5:17 PM, Andrus Adamchik wrote:
Interesting... Looking at your log I see this:
15:33:08.267 (2) FE=> Parse(stmt=S_1,query="BEGIN",oids={})
.....
15:33:08.268 (2) FE=> Parse(stmt=null,query="SELECT ....
....
15:33:28.461 (2) FE=> Parse(stmt=S_2,query="COMMIT",oids={})
So transaction is clearly committed. But of course connection is
not closed. It is returned to the pool instead. Still looks like a
driver bug to me.
Andrus
Sorry, you said "sometimes". Just noticed that the first case indeed
doesn't commit. Just thought of another potential source of leaks -
Cayenne iterated queries. Are you using any of those?
http://cayenne.apache.org/doc/iterating-through-data-rows.html
Andrus
