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

[Chris Withers]

Bo M. Maryniuck wrote:

> Well, maybe I am wrong, but Zope really drops the connections -- I had tested 
> it specially. Zope 2.6.2 and 2.7.b2 doing this -- I can show you. I had 
> tested it with Oracle. Just turn off the reconnect in __setstate__ of the 
> Connection.py and you will see it. Maybe it should not, but practically it 
> does. The same, when you put the connection class to the session. Strange, 
> that connections sometimes are dropped after few seconds or minutes, if you 
> do nothing. 

What size is your ZODB object cache? If the DA object goes out of the cache, the 
connection will be dropped. I think that's why the code is there in __setstate__...

> But keep in mind, that usually 
> "Flush Cache" could not help either.

What do you mean by this?

Chris