RE: [Zope-DB] Closing idle DCoracle2 Connections?

2005-10-24 Thread Germer, Carsten
: Dieter Maurer [mailto:[EMAIL PROTECTED] Sent: Saturday, October 22, 2005 8:07 PM To: Matthew T. Kromer Cc: Chris Withers; Germer, Carsten; zope-db@zope.org Subject: Re: [Zope-DB] Closing idle DCoracle2 Connections? Matthew T. Kromer wrote at 2005-10-21 20:39 -0400: ... What happens with Zope

Re: [Zope-DB] Closing idle DCoracle2 Connections?

2005-10-21 Thread Chris Withers
Cynthia Kiser wrote: open. FYI just closing the database connection via the ZMI does not release the idle connections Oracle still sees. Yes, that button actually does nothing ;-) Chris -- Simplistix - Content Management, Zope Python Consulting - http://www.simplistix.co.uk

Re: [Zope-DB] Closing idle DCoracle2 Connections?

2005-10-21 Thread Chris Withers
Dieter Maurer wrote: Usually, there is not need for a sophisticated connection management. Just do not create unnecessary DA instances. Yes, this is the most common mistake... Bugs should be fixed and not worked around with more complex software (complex connection management). Well, it

Re: [Zope-DB] Closing idle DCoracle2 Connections?

2005-10-20 Thread Dieter Maurer
Germer, Carsten wrote at 2005-10-20 11:16 +0200: ... 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