[Zope-DB] Introduction and question

[Matthew T. Kromer]

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