-----Original Message----- From: Jim Sanford [mailto:jsanford@atinucleus.com] Sent: Thursday, September 16, 1999 4:54 PM To: IPM Return requested (Receipt notification requested) Subject: [Zope] ZODBCA connection question
Is it possible to set Zope to close an open ODBC connection once it has been idle for a specified period of time, then reopen the connection when traffic comes in that needs it?
If a database adapter sits around in memory unused long enough, Zope will deactivate it (store it to disk, remove it from memory), when it does this, the connection goes away. When the object is activated, it is re-connected. Idle timeout, on the other hand, should be a function of the server. It is DA specific whether or not the DA is smart enough to reconnect after being idle timed out by the server. -Michel