[Zope-DB] Closing idle DCoracle2 Connections?

Germer, Carsten carsten.germer at desy.de
Thu Oct 20 05:16:46 EDT 2005

Hello everyone,

As we start to use our zope-Ora connection more frequently our database
administrator complains that he sees a lot of idle conections.

I know theres "connection.close()" in DCOra2 but does anyone know of a
way to autmatically close a DCOra within Zope when idle soandso long? Or
any other way to adress such a problem?

I know that I wouldn't want the connection being closed from Oracles
side as I have read in the mailinglist that DCOracle would still think
the connection is open and generate an error.

Our Specs atm:
 Oracle version strings:
    * TNS for Solaris: : (Production)
    * PL/SQL : (Production)
    * NLSRTL : (Production)
    * Oracle9i Enterprise Edition : (Production)
    * DCOracle2: (cvs release) -- DCOracle2 1.103 (dco2: 1.137

Thanks in Advance /Carsten

Carsten Germer         Deutsches Elektronen Synchrotron (Web-Office, IT)
phone:  +49-40-8998-1661                                    Notkestr. 85
web: http://wof.desy.de                                    22607 Hamburg
e-mail: carsten.germer at desy.de                                   Germany

More information about the Zope-DB mailing list