[Zope-DB] Introduction and question

[Matthew T. Kromer]

You'll have to visit cvs.zope.org to get Chris Wither's patches, either 
through the webcvs interface or via anonymous CVS.

Yes, ZOracleDA (the buggier part of DCOracle2 *wink*) commits at the 
end of each web request that it is invoked on; you don't need to (and 
should not) explicitly commit.  The connection is NOT closed; each 
connection object will keep its connection open.  Because the 
connection objects get loaded from the ZODB on a per-thread basis, that 
means under normal circumstances you can have four open connections to 
Oracle.

On Oct 19, 2004, at 3:34 AM, Germer, Carsten wrote:

> 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
>>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB at zope.org
> http://mail.zope.org/mailman/listinfo/zope-db