- Zope-Dev - Zope lists

Re: [Zope-dev] ZODBCA questions...
by Dieter Maurer 09 Apr '01

09 Apr '01

Andy McKay writes: > According to the Database Adapter RoadMap > (http://www.zope.org/Members/petrilli/DARoadmap) ZODBCA will be level 2 > compliant at one point. Yet ZODBCA hasnt been touched since 1999. Is ZODBCA > level 2 compliant? Recent posts to the list suggest that not (--> mail archives). ZmxODBCDA was said to solve the problem.... Dieter

1 0

RE: [Zope-dev] Windows FAQ / Help area?
by Bryan Baszczewski 09 Apr '01

09 Apr '01

How about database access (i.e. ODBC adapters) -----Original Message----- From: zope-dev-admin(a)zope.org [mailto:zope-dev-admin@zope.org]On Behalf Of Andy McKay Sent: Monday, April 09, 2001 3:51 PM To: zope-dev(a)zope.org Subject: [Zope-dev] Windows FAQ / Help area? Just thinking how many little tidbits I know related to running Zope on Windows that are very platform and installation specific. Do people think it would be a good idea to start at least a wiki / faq section somewhere covering this? Do other windows users think there is enough stuff to put in there? Things I can think of off the top of my head: windows service, getting stdout when running as a service and I was about to add ZEO, but thats been fixed... Cheers. -- Andy McKay. _______________________________________________ Zope-Dev maillist - Zope-Dev(a)zope.org http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )

3 3

Re: [Zope-dev] ZODBCA questions...
by Andy McKay 09 Apr '01

09 Apr '01

According to the Database Adapter RoadMap (http://www.zope.org/Members/petrilli/DARoadmap) ZODBCA will be level 2 compliant at one point. Yet ZODBCA hasnt been touched since 1999. Is ZODBCA level 2 compliant? Cheers. -- Andy McKay. ----- Original Message ----- From: "Bryan Baszczewski" <bryanbz(a)2s2i.com> To: "'Andy McKay'" <andym(a)ActiveState.com> Sent: Monday, April 09, 2001 11:28 AM Subject: RE: [Zope-dev] ZODBCA questions... > Andy, We experienced bigtime problems with ZODBC too. ZODBC locked all > other requests out when waiting for a complex query. Upgrade to ZmxODBC > database adapter (search on zope.org to find it). We found ZmxODBC to be > alot better without locking requests. BUT...it costs money(!) > and seems no one else uses this though as SQL Server isnt widely supported > by Digital Creations. A shame really being that SQL Server is an excellent > database. > > For verificaion of your problem, check out the plans for ZODBC the "Database > Adapter RoadMap". > > -----Original Message----- > From: Andy McKay [mailto:andym@ActiveState.com] > Sent: Monday, April 09, 2001 1:46 PM > To: zope-dev(a)zope.org > Subject: [Zope-dev] ZODBCA questions... > > > Im getting some performance issues with my sites, im connecting Zope to a > SQL Server (not using ZEO). I've got suspicion, but no proof, that its > ZODBCA that is the problem. Does anyone have experiences with this on large > sites and / or a suggestion to replace it? > > Cheers. > -- > Andy McKay. > > > > > _______________________________________________ > Zope-Dev maillist - Zope-Dev(a)zope.org > http://lists.zope.org/mailman/listinfo/zope-dev > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope ) >

2 1

Re: [Zope-dev] Bug in ZMI?
by Dieter Maurer 09 Apr '01

09 Apr '01

E. Seifert writes: > I think I encountered a problem with the ZMI. > Everytime I added a new property to the memory cache object the list doesn't > display them correctly. > They are concatenated; no space between them. > > Is this a known bug? It is a bug - in the latest CVS, too. Put it into the collector. A patch is to change "Products/StandardCacheManagers/dtml/propsRCM.dtml" from: <textarea name="request_vars:lines" rows="5" cols="30"><dtml-in request_vars>&dtml-sequence-item;</dtml-in></textarea> to <textarea name="request_vars:lines" rows="5" cols="30"><dtml-in request_vars>&dtml-sequence-item; </dtml-in></textarea> The newline before "</dtml-in>" is essential. Dieter

1 0

Windows FAQ / Help area?
by Andy McKay 09 Apr '01

09 Apr '01

Just thinking how many little tidbits I know related to running Zope on Windows that are very platform and installation specific. Do people think it would be a good idea to start at least a wiki / faq section somewhere covering this? Do other windows users think there is enough stuff to put in there? Things I can think of off the top of my head: windows service, getting stdout when running as a service and I was about to add ZEO, but thats been fixed... Cheers. -- Andy McKay.

1 0

Re: [Zope-dev] ZODBCA questions...
by Andy McKay 09 Apr '01

09 Apr '01

Well I havent been able to prove its ZODBCA yet... the other alternative is perlDBI but that has a small performance hit. Cheers. -- Andy McKay. ----- Original Message ----- From: "Bryan Baszczewski" <bryanbz(a)2s2i.com> To: "'Andy McKay'" <andym(a)ActiveState.com> Sent: Monday, April 09, 2001 11:28 AM Subject: RE: [Zope-dev] ZODBCA questions... > Andy, We experienced bigtime problems with ZODBC too. ZODBC locked all > other requests out when waiting for a complex query. Upgrade to ZmxODBC > database adapter (search on zope.org to find it). We found ZmxODBC to be > alot better without locking requests. BUT...it costs money(!) > and seems no one else uses this though as SQL Server isnt widely supported > by Digital Creations. A shame really being that SQL Server is an excellent > database. > > For verificaion of your problem, check out the plans for ZODBC the "Database > Adapter RoadMap". > > -----Original Message----- > From: Andy McKay [mailto:andym@ActiveState.com] > Sent: Monday, April 09, 2001 1:46 PM > To: zope-dev(a)zope.org > Subject: [Zope-dev] ZODBCA questions... > > > Im getting some performance issues with my sites, im connecting Zope to a > SQL Server (not using ZEO). I've got suspicion, but no proof, that its > ZODBCA that is the problem. Does anyone have experiences with this on large > sites and / or a suggestion to replace it? > > Cheers. > -- > Andy McKay. > > > > > _______________________________________________ > Zope-Dev maillist - Zope-Dev(a)zope.org > http://lists.zope.org/mailman/listinfo/zope-dev > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope ) >

1 0

ZPatterns Attribute Provider Problem
by cs＠comlounge.net 09 Apr '01

09 Apr '01

Hi everybody! I am trying to write some attribute provider for storing data inside an SQL table as I am bored of typing parameter lists over and over again (e.g. in every ZSQL method, in every SkinScript method etc.) The problem now is that adding a new row to the table (and thus adding a new object to the rack) is working well but updating an object does not. Basically the main problem is that _objectChanged is not called in my provider. What I did is the following: - If an attribute of the propsheet is changed, _SetAttributeFor is called and stores it into the cache (as I don't want to update the database for every attribute change). - _objectChanged is then supposed to create an sql query and execute it. This - as said - is actually not happening, as the whole method is not called. - My namesForRegistration looks like this: def namesForRegistration(self,container): """ return names for registration """ return { 'provides':('handlers','attributes'), 'getattr': self._attribs.keys(), 'setattr': self._attribs.keys(), 'delattr': self._attribs.keys() } with self._attribs containing the attributes my provider is responsible for. So is there any reason why _objectChanged is not called? Actually I am a bit confused when reading the ZPatterns source which should call it.. ;-) So which are the conditions under which it's supposed to be called? (_objectAdded() as said before is called actually..) I hope someone can help me :) cheers, Christian -- COM.lounge http://comlounge.net/ communication & design info(a)comlounge.net

1 1

Proxy Roles Problem
by Chris Withers 09 Apr '01

09 Apr '01

Hi, I need to have one anonymously accessible form in the middle of a restricted area of a site. This form needs to use lots of stuff that isn't usually available anonymously. Fine thinks me, I'll give the anonymous form (a DTML method) a proxy role of manager. This doesn't help much, in goes ZDebug (thankyou, yet again Shane ;-) Anyway, it appears that proxy roles are 'carried on'. So, I give my method a proxy role, it calls another method which in turn calls another. That third method gets caleld with Anonymous permissions again. What gives? Is this how its intended? It's not very helpful and means I haev to give loads of extar mthods the proxy roles unneccessarily :-S cheers, Chris

1 0

ZSQL methods seriously broken
by Martijn Faassen 09 Apr '01

09 Apr '01

Hi there, Type marshalling is seriously broken in ZSQL methods. The bug is a bit subtle, though. There are reports of this in the collector almost a month old, and the severity of this bug is pretty high (could seriously disrupt Zope upgrades to recent versions which apparently have this bug; I don't know when it was introduced), so I'm making some extra noise about it here. First how to reproduce the bug: Create a ZSQL method 'my_method'. Give it an argument: foo:int and some body. Now make a DTML Method, 'test_my_method' Do something like this following: <dtml-call "my_method(foo='blah')"> What should happen is a failure of 'my_method'. my_method however happily continues, treating 'foo' as a string. This can lead to subtle bugs; you push in a '0' string expecting the type marshalling will make it a 0. Then you put a <dtml-if "foo == 0"> somewhere in your ZSQL template, and the condition will never be true, as foo will always be a string. This bug is relatively hard to discover; the ZSQL *test screen* does do the proper marshalling, as the marshalling bits are placed in the test form body (<input type="text" name="foo:int">). And of course for most ZSQL methods, you use <dtml-sqlvar foo type="int">, which does its own marshalling. I've seen this bug in 2.3.0 and 2.3.1. From collector reports it also looks like default arguments don't work either. I hope the bug is hereby noted by the powers that be. :) The fix is along the lines of using the ZPublisher Converters module in ZSQL methods somehow, I suspect. Regards, Martijn

1 1

Catalog Indexes.
by Erik Enge 09 Apr '01

09 Apr '01

I need some help with indexes. I'm confused about what I can index in which Index. Which index does not remove numbers? Which of them do I use to index a telephone number (containing characters). What about email addresses? Special characters? *oink* Help...

3 4