Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
Hi Cynthia, Cynthia Kiser wrote: When you do our own connection management, are you able to avoid DCOracle2 leaking connections? In our Zope 2.6.1/DCOracle2-1.3b server, we accumulate sessions where Oracle is waiting for a response from Zope, but Zope apparently thinks it closed that connection and opened a new one. If you google for my name, Oracle and Zope you'll find lots of information on the problem ;-) It's basically ZOracleDA's funny idea of connection pooling that causes the problem. Unless your ZSQL methods are hammered heavilly, you'll see plenty of unused oracle sessions. These aren't being leaked as you suggest, just not used very often. This results in "Oracle Not Connected" errors if your DBA sets a timeout on unused Oracle sessions... Manually closing and reopening the connection does not clean up the forgotten sessions, so I periodically (~monthly) restart the Zope server to clean up. Control Panel -> Database -> Main -> Flush Cache will have the same effect... me with the impression that its connection closing function did not work. It doesn't ;-) cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
Matthew T. Kromer wrote: Chris Withers's branch of DCOracle2 has some changes that help the connection pooling problem. And rumour has it I'm going to get some serious time to work on this soon! Matt, you up for fixing any C-level bugs that crawl out of the woodwork? You can also consider using e-Genix's mxODBC adapter. This is a no-go if your Oracle people go "huh? ODBC? that's deprecated rubbish and you ain't using it" ;-) cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
Chris Withers wrote: > Matthew T. Kromer wrote: > >> Chris Withers's branch of DCOracle2 has some changes that help the >> connection pooling problem. > > > And rumour has it I'm going to get some serious time to work on this > soon! Matt, you up for fixing any C-level bugs that crawl out of the > woodwork? > >> You can also consider using eGenix's mxODBC adapter. > > > This is a no-go if your Oracle people go "huh? ODBC? that's deprecated > rubbish and you ain't using it" ;-) Depends on what people you're talking to, I guess... Some people just love sitting hours in front of a their box to get things running - other's prefer to get the job done in 30 minutes and spend the rest of day doing something more interesting ;-) BTW, would calling it mxOracle Zope DA help ? (just testing waters here ;-) -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Source (#1, Apr 19 2005) >>> Python/Zope Consulting and Support ...http://www.egenix.com/ >>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ >>> mxODBC, mxDateTime, mxTextTools ...http://python.egenix.com/ ::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
M.-A. Lemburg wrote: This is a no-go if your Oracle people go "huh? ODBC? that's deprecated rubbish and you ain't using it" ;-) Depends on what people you're talking to, I guess... Oracle DBA's who know a helluva lot more than me about Oracle ;-) Why are they saying ODBC is deprecated? Is it? Is ADO the way to go here? (as you can tell, I'm fairly clueless when it comes to MS ways into Oracle ;-) ) BTW, would calling it mxOracle Zope DA help ? (just testing waters here ;-) Sadly, not in the slightest. For me, only normal oracle listeners will ever be available :-( cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
Chris Withers wrote: > M.-A. Lemburg wrote: > >>> This is a no-go if your Oracle people go "huh? ODBC? that's deprecated >>> rubbish and you ain't using it" ;-) >> >> >> Depends on what people you're talking to, I guess... > > > Oracle DBA's who know a helluva lot more than me about Oracle ;-) > > Why are they saying ODBC is deprecated? Is it? Is ADO the way to go > here? (as you can tell, I'm fairly clueless when it comes to MS ways > into Oracle ;-) ) Not sure why they think that ODBC is deprecated - Oracle is happily working on their ODBC driver and it's one of the best bets you can find out there: http://www.oracle.com/technology/software/tech/windows/odbc/index.html The only thing that's deprecated in the context of ODBC and Oracle is the MS Oracle driver - at least that's how things currently look (you never know with MS vs. Oracle, e.g. they just published a new .NET provider ): http://support.microsoft.com/kb/q244661/ Note that ADO is just a layer on top of OLE DB and/or ODBC and makes programming a bit easier for C++ apps and the like. It doesn't really buy you anything when used from Python - just adds one more layer to worry about :-) See the MS MDAC roadmap for more details: http://msdn.microsoft.com/data/mdac/default.aspx?pull=/library/en-us/dnmdac/html/data_mdacroadmap.asp It is interesting to see things like e.g. DAO which was en vogue a few years ago being listed as obsolete data access technology. >> BTW, would calling it mxOracle Zope DA help ? (just >> testing waters here ;-) > > Sadly, not in the slightest. For me, only normal oracle listeners will > ever be available :-( Would a native Oracle interface help ? -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Source (#1, Apr 19 2005) >>> Python/Zope Consulting and Support ...http://www.egenix.com/ >>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ >>> mxODBC, mxDateTime, mxTextTools ...http://python.egenix.com/ ::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] RAM Cache setting for ZEO
Hi, We are using zope 2.7.2 with 1 ZEO server and 4 zeo clients. We are trying to use RAM cache manager to effect to all the zeo clients. How we can configure ram cache manager for all four zeo clients? regards, Deepak ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db