[Zope-DB] Introduction and question

Matthew T. Kromer matt at bane.mi.org
Mon Oct 18 08:56:45 EDT 2004

DCOracle2 is pretty bad about shutting down idle connections.  You may  
try Chris Wither's patches and see if they help you.
Zope in general doesn't have an "idle-ness" notion; it can't wake up  
after a period of inactivity to shut down connections.

On Oct 18, 2004, at 4:36 AM, Germer, Carsten wrote:

> Hello everyone,
> I'm Carsten Germer from the research facility DESY in Hamburg, Germany.
> We're using Zope and ZMS to centraly set up and manage our many  
> different
> research groups public websites.
> Now, there is many Data that should be made accessible through their  
> sites
> in Oracle 9i Database tables, we basically just need to display this  
> or that
> table on this or that page.
> I just begun testing DCOracle2 in the core Zope (without ZMS-AddOns)  
> and it
> works fine for me.
> I have one question, though: Our DBA is a bit picky about idle  
> connections
> which I seem to have pretty often. Every time I look in the  
> "status"-Tab it
> says "The database connection is closed." which sounds good to me :)
> 1. I usually shut down and start zope once a night, does this open any
> connections?
> 2. When anyone accesses a page with a query display or maybe changes
> something (Z SQL Methods with Page templates) does this commit and or  
> close
> the connection automatically after usage?
> I didn't find some kind of "timeout settings" or the like on the  
> Database
> connection...
> 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
> ----------------------------------------------------------------------- 
> -
> _______________________________________________
> Zope-DB mailing list
> Zope-DB at zope.org
> http://mail.zope.org/mailman/listinfo/zope-db

More information about the Zope-DB mailing list