Saga continues ([Zope-DB] DCOracle2: close connection doesn't)

[Chris Withers]

Dieter Maurer wrote:

> Zope does not drop the connection and it reexecutes the query or
> raises an exception when it notices that the connection has been
> dropped.

Where's the code that does this?
(It doesn't always work, see the start of this thread ;-)

> However, the database server never detects that it waits for
> data from a cut connection. We have to restart the server
> regularly to get rid of the piling up defunct sessions.

This sounds familiar, although one of the problems I'm trying to solve is 
sockets piling up in a CLOSED_WAIT state on the Oracle(or maybe Zope?) server. 
They go away when the ZODB cache is minimized...

Chris