[Zope-DB] DB2: accumulating db-connections

Matthew T. Kromer matt@zope.com
Fri, 21 Jun 2002 09:58:42 -0400

Stephan Herschel wrote:

> Hi,
> We're using ZDB2DA as an interface to DB2 and we're experiencing the 
> problem that the connections from zope to the database seem to be 
> increasing over time. So from time to time i have to reset all 
> connections.
> Has anybody seen similar behaviour with this or other database 
> adapters? Any solutions?
> Thanks in advance!
> Stephan

It usually indicates something is trying to hold on to connection 
objects.  This may be something at the DA level that needs to be fixed, 
or it may represent query results which hold on to their connection, but 
the query results have been cached.

Matt Kromer
Zope Corporation  http://www.zope.com/