[Zope-DB] Introduction and question

[Germer, Carsten]

Hmm, I read quite a lot about Chris Wither's patches, forgive my ignorance,
where can I find them? Searched google and zope.org...

Any info on my question 2?
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?

Cheers /Carsten


>-----Original Message-----
>From: Matthew T. Kromer [mailto:matt at bane.mi.org] 
>Sent: Monday, October 18, 2004 2:57 PM
>To: Germer, Carsten
>Cc: 'zope-db at zope.org'
>Subject: Re: [Zope-DB] Introduction and question
>
>
>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
>