[Zope] ZODBCA connection question

Michel Pelletier michel@digicool.com
Thu, 16 Sep 1999 17:33:43 -0400


> -----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