RE: [Zope-DB] Closing idle DCoracle2 Connections?
Ok, that's a bit much for my question I guess... I gather from all your mails that I can not "close" a database connection periodically or on event from Zope (Script or whatever)? Any hands-down clues what I can do to prevent db-conns from ideling around? /Carsten >-Original Message- >From: 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 and DCOracle2 I think is when the DA >>connection object is ghosted, it doesn't know about it, and thus >>doesn't close its connection. > >Why not? > > When the DA instance is ghosted, the "db" object is deleted > (last reference released). > > In an optimal world, the deletion of the "db" object would release > the last reference to the DCOracle connection and this > would close the connection to Oracle before the memory > is released. > >> ... >>The close is implicit when the >>connection object is destroyed, but usually there's so much stuff >>loaded that *someone* has a reference to the connection. > >That's the bug. > >There should be no references to DCOracle resources outside >the "db" object (at least, Zope's DA/ZSQL do not require >such references outside). Thus, when the "db" object goes away, >the "DCOracle" resources should, too. > >>However, the code is still geared around OCI8 and some Oracle >9 code, >>its due for some refactoring in a big way to deal with the profusion >>of handle-driven objects now much more prevalent in Oracle 10. > >-- >Dieter > ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] Closing idle DCoracle2 Connections?
Hello everyone, 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 within Zope when idle soandso long? Or any other way to adress such a problem? I know that I wouldn't want the connection being closed from Oracles side as I have read in the mailinglist that DCOracle would still think the connection is open and generate an error. Our Specs atm: Oracle version strings: * TNS for Solaris: : 9.2.0.5.0 (Production) * PL/SQL : 9.2.0.5.0 (Production) * NLSRTL : 9.2.0.5.0 (Production) * Oracle9i Enterprise Edition : 9.2.0.5.0 (Production) * DCOracle2: (cvs release) -- DCOracle2 1.103 (dco2: 1.137 -DORACLE8i -DORACLE9i -DUSEOBJECT -Dlinux -DNATIVENUMERIC=1 -D_REENTRANT ) Thanks in Advance /Carsten Carsten Germer Deutsches Elektronen Synchrotron (Web-Office, IT) phone: +49-40-8998-1661Notkestr. 85 web: http://wof.desy.de22607 Hamburg e-mail: [EMAIL PROTECTED] Germany ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
RE: [Zope-DB] DCOracle2 1.3.beta common Problem, where to get latest build?
Gah! Think simple, Carsten... Although I tested everything the environment variables didn't find their way into that specific instance. Fixed that and works now. Question: Should I get the latest DCO from the cvs anyway or should I better stay with 1.3b? Cheers /Carsten >-Original Message- >From: Matthew T. Kromer [mailto:[EMAIL PROTECTED] >Sent: Friday, July 08, 2005 12:44 PM >To: Germer, Carsten >Cc: zope-db@zope.org >Subject: Re: [Zope-DB] DCOracle2 1.3.beta common Problem, >where to get latest build? > > >You can get the newer code from cvs.zope.org. The particular error >your getting usually indicates a permission problem with >ORACLE_HOME's >directory or not having the ORACLE_HOME environment variable set >properly. The libraries can't even read the message >repository in this >instance. > > >On Jul 8, 2005, at 5:27 AM, Germer, Carsten wrote: > >> Hi everyone, >> >> Oracle 9i works fine with SQLPlus on my Suse 8.2 machine with Zope >> 2.7.5-final. >> >> I downloaded and installed DCOracle 1.3 beta from >> http://www.zope.org/Members/matt/dco2. A few problems with compiling >> where resolved easily. >> >> Now I get that infamous error >> ... >> Module Products.DCOracle2.DCOracle2.DCOracle2, line 185, in connect >> BadRequest: Invalid connection string: >> xxx/[EMAIL PROTECTED] >> >> >> I read up on mailing lists and found that someone says that there's a >> newer version out >> "Also, the latest cvs build of dco2.so is 1.137 or so, so you're >> running >> about 8 patches behind at your current code base." >> >> Where can I get a more recent version of DCOacle 2? >> Or has anyone any other hint on how to resolve this? >> >> Cheers /Carsten >> >> >--- > >> - >> Carsten Germer Deutsches Elektronen Synchrotron >(Web-Office, >> IT) >> phone: +49-40-8998-1661 >Notkestr. >> 85 >> web: http://wof.desy.de22607 >> Hamburg >> e-mail: [EMAIL PROTECTED] >> Germany >> >--- > >> - >> ___ >> Zope-DB mailing list >> Zope-DB@zope.org >> http://mail.zope.org/mailman/listinfo/zope-db > > ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] DCOracle2 1.3.beta common Problem, where to get latest build?
Hi everyone, Oracle 9i works fine with SQLPlus on my Suse 8.2 machine with Zope 2.7.5-final. I downloaded and installed DCOracle 1.3 beta from http://www.zope.org/Members/matt/dco2. A few problems with compiling where resolved easily. Now I get that infamous error ... Module Products.DCOracle2.DCOracle2.DCOracle2, line 185, in connect BadRequest: Invalid connection string: xxx/[EMAIL PROTECTED] I read up on mailing lists and found that someone says that there's a newer version out "Also, the latest cvs build of dco2.so is 1.137 or so, so you're running about 8 patches behind at your current code base." Where can I get a more recent version of DCOacle 2? Or has anyone any other hint on how to resolve this? Cheers /Carsten Carsten Germer Deutsches Elektronen Synchrotron (Web-Office, IT) phone: +49-40-8998-1661Notkestr. 85 web: http://wof.desy.de22607 Hamburg e-mail: [EMAIL PROTECTED] Germany ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db