[egenix-users] mxODBC Zope DA and Linux Zope -- Connections not being disconnected

[M.-A. Lemburg]

On 2007-03-13 13:24, David Krosel wrote:
> Hello,
> 
> The problem happened again... I didn't change the configuration yet
> since it was a production system.
> 
> However, from Zope, the following "Connection Pool" information showed up:
> 
> --------------------------------------
> Pool size: 21
> Physical connections: 0 open
> Total mxODBC connnections: (24,0)
> --------------------------------------
> 
> Does this make since? 24 connections but pool of 21 ?

The Zope DA uses the pool size as guideline for managing
the number of open connections. It does connection trimming
in a better-safe-than-sorry mode which monitors usage of
the connections and doesn't force closing of connections
still marked as being in use by other threads.

It's also possible that you keep mxODBC connections alive
by keeping a reference to them elsewhere in the Zope process.
This depends on how you use the mxODBC Zope DA connection objects.

Regards,
-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Mar 14 2007)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! ::::