- Zope - Zope lists

RE: ZODBC problem (and ZmxODBC)
by Capesius, Alan 07 Mar '01

07 Mar '01

Excellent. The ZmxODBC driver has resolved the problem for me. Performance is now unaffected by the slow queries. I'm using Access and SQL7 dbs, not sure if Access ODBC is multi-threaded, so I may need to run a mix of drivers, but the test server hasn't crashed yet. A note on the ZmxODBC install, the docs indicate that you should copy the mx folder to the Shared folder. This will not work (and is the default). The coding requires that you move the mx folder up one level after extraction it into the Zope tree. It should be at ZopePath\lib\python\mx Thanks Bryan, Alan >>>-----Original Message----- >>>From: Bryan Baszczewski [mailto:bryanbz@2s2i.com] >>>Sent: Wednesday, March 07, 2001 1:08 PM >>>To: 'Capesius, Alan'; zope(a)zope.org >>>Cc: zope-dev(a)zope.org >>>Subject: RE: [Zope-dev] RE: ZODBC problem >>> >>> >>>Alan, I am having a similar lock-out problem while >>>performing a complex >>>query on SQL Server 2K. All other hits cannot connect until >>>the query >>>returns the results. My research has so far taken me here: >>> >>>http://www.zope.org/Members/petrilli/DARoadmap >>>Which is telling me I am probably using at most a Level-2 DA >>>with my ZODBC. >>> >>>And then here: >>> >>>http://www.zope.org/Members/djay/ZmxODBC/ZmxODBC_0_0_2.tgz/README >>>Which is a Level-3 mxZODBC DA (multithreaded). >>> >>>If anyone sees a problem with what I am about to do, let me >>>know. What do >>>you think? >>> >>> >>> >>>-----Original Message----- >>>From: zope-dev-admin(a)zope.org >>>[mailto:zope-dev-admin@zope.org]On Behalf >>>Of Capesius, Alan >>>Sent: Wednesday, March 07, 2001 12:31 PM >>>To: zope(a)zope.org >>>Cc: zope-dev(a)zope.org >>>Subject: [Zope-dev] RE: ZODBC problem >>> >>> >>>Thanks Dieter, I was kinda looking for a solution, I >>>reviewed the mailing >>>lists but do not see any solutions. I've done some more testing here: >>> >>>Summary: The user selects an involved financial report. The >>>report takes >>>about 55 seconds for Zope to prepare. The first second is >>>the SQL server >>>request and reply. The remaining time is Zope processing >>>(dual 200mhz NT >>>box). >>> >>>My queries are SELECT JOINS. No tables are modified at the server. >>> >>>The problem I see here is that Zope/ZODBCDA is holding the >>>connection to SQL >>>open via ODBC until all processing is complete and then >>>issuing an SQL >>>statement: IF @@TRANCOUNT>0 COMMIT TRAN >>> >>>Zope could free up this connection after one second. (at >>>least in this case) >>>Until Zope does the commit, other users are locked out. >>> >>>For read only queries, there is no need to have the request under >>>transaction control. In any case, Zope should be able to >>>early release the >>>SQL connection and then process on the results. >>> >>>Certainly increasing processor speed will mask this problem >>>and provide >>>better response to users, but I'm hoping for a real fix. >>> >>>Thanks, >>>Alan >>> >>>Network Monitor trace Wed 03/07/01 10:51:50 c:\cap1.TXT >>> >>>Frame Time Src MAC Addr Dst MAC Addr Protocol >>>1 4.413 006008F6062B COMPAQ851F04 TCP >>>2 4.413 006008F6062B COMPAQ851F04 TCP >>>3 4.413 006008F6062B COMPAQ851F04 TCP >>>[....] >>>193 5.072 006008F6062B COMPAQ851F04 TCP >>>194 5.073 COMPAQ851F04 006008F6062B TCP >>>195 5.090 COMPAQ851F04 006008F6062B TCP >>>196 5.090 006008F6062B COMPAQ851F04 TCP >>>197 5.090 006008F6062B COMPAQ851F04 TCP >>>198 5.091 COMPAQ851F04 006008F6062B TCP >>>199 5.109 COMPAQ851F04 006008F6062B TCP >>>200 5.127 COMPAQ851F04 006008F6062B TCP // SQL >>>server goes idle >>>after this >>> >>>// python DTML processing occurs here >>> >>> >>>201 10.834 006008F6062B COMPAQ851F04 TCP // not >>>sure what this is, >>>Data is 0xA8 >>>202 10.834 COMPAQ851F04 006008F6062B TCP // reply, >>>data is empty >>> >>>// page returns to user at 60 second mark >>>// then Zope closes the connection >>>203 60.385 COMPAQ851F04 006008F6062B TCP >>> SQL: IF @@TRANCOUNT>0 COMMIT TRAN >>>204 60.386 006008F6062B COMPAQ851F04 TCP >>>205 60.601 COMPAQ851F04 006008F6062B TCP >>> >>> >>>>Capesius, Alan writes: >>>> > ... >>>> > with further testing I >>>> > have determined that the Zope server itself is not >>>locking up, but >>>rather >>>> > requests to the database (MS SQL7 via ZODBCDA) seem to >>>be queueing up. >>> >>>>My memory tells me faintly that such an issue has already been >>>>discussed in the mailing lists (zope, zope-dev). >>>>When I remember right, ZODBCDA synchronizes all database requests >>>>--> searchable list archives... >>> >>> >>>>Dieter >>> >>>_______________________________________________ >>>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

Methods to connect Linux Zope to ODBC database
by Chris Beaumont 07 Mar '01

07 Mar '01

Hello, I'm looking for a way to enable our (Debian) Linux-based Zope installation to connect for some very simple (read-only) interaction with a FileMaker Pro database that is available via ODBC. I'm wondering what others have used to do something like this. I realize that there are commercial 'bridge' products out there that will make the connection, but as far as I can see, there isnt an ODBC DA for Linux. Is there any workaround? Or does anyone have any suggestions, or experience with any method that they would be willing to share? Thanks. Chris Beaumont cbeaumon(a)msri.org

2 1

Re: [Zope] Subtracting PreciseTime
by Dieter Maurer 07 Mar '01

07 Mar '01

Paul Zwarts writes: > I have two dates that I want to find the difference in minutes or hours > (preferably minutes) > > zdate 2001/03/07 17:08:00 GMT+1 > start_date 2001/03/07 16:41:14 GMT+1 > > What I try: > > <dtml-var expr="_.DateTime(zdate-start_date).PreciseTime()"> Please read the "DateTime" documentation carefully. I expect, both "zdate" and "start_date" are DateTime objects. Then, "zdate-start_date" is a floating point number representing the difference in days! The "DateTime" constructor interprets a float as a number of seconds since the epoch which is apparently "1970/01/01 01:00:00". Thus, the construct above will not give you what you want. Try: <dtml-var expr="(zdate-start_date)*24*60"> Dieter

1 0

Re: [Zope] Creating a directory using Zcatalog and either tree or some other method
by Dieter Maurer 07 Mar '01

07 Mar '01

Chris Muldrow writes: > I've got news stories in a Zcatalog. I want to build a directory of said > stories.... > I want to > display them under headers using the following criteria: If > Category=='Local', then print a header for the localities and sort them. > Otherwise, print a header for the categories. Here's how it should look: I am sure, I do not understand precisely what you want. But, you may look at "dtml-in"'s grouping support ("sequence-first-XXX", "sequence-last-XXX") after you sorted your stories appropriately. More details in URL:http://www.dieter.handshake.de/pyprojects/zope/book/chap3.html Dieter

1 0

Re: [Zope] dummy class security problem
by Dieter Maurer 07 Mar '01

07 Mar '01

magnus/Websys(a)websys.no writes: > This is from one of the dtml-tree HOWTOs on zope.org. It doesn't work with > the new security mechanism. When I test it I get the traceback at the bottom > of the mail. Any suggestions for making the 'name' property of > _dummy 'public' to Zope? You want to read Brian's paper on Zope security (--> www.zope.org) Dieter

1 0

Re: [Zope] ZCatalog and ExtFile
by Dieter Maurer 07 Mar '01

07 Mar '01

Andrew Williams writes: > ... > However, ExtFile does not update ZCatalog whenever I add another ExtFile > object to the ZODB. I've checked the ExtFile code, and indeed, ExtFile > inherits from Products.ZCatalog.CatalogAwareness, CatalogAware. You are aware, that "CatalogAware" requires the catalog to have a specific id and be available through acquisition? Dieter

1 0

Re: [Zope] New User: MS IIS and Exchange
by Dieter Maurer 07 Mar '01

07 Mar '01

HIND, Philip writes: > Eventually I will want to start using Zope to serve the site/s but I imaging > I will need to change the port number so it runs from > http://www.ourhost.com/ rather than http://www.ourhost.com:8080/ > But I am worried that if I change this it will cause the exchange system to > fail many of our users access their e-mail using the Exchange webmail system > at http://www.ourpost.com/exchange It would not be a problem with Apache. I cannot say something about IIS. Dieter

1 0

Re: [Zope] What are you doing with Zope?
by Dieter Maurer 07 Mar '01

07 Mar '01

D.Turpie(a)open.ac.uk writes: > I would be interested to learn what applications (Intranet, web site > Management, specific projects etc.) people are developing using Zope and any > benefits/limitations you may have found using zope. URL:http://www.european-e-business.com Benefits: * Python extensible * flexible * good RDBMS integration * lots of tools (called products) available * open source .... Limitations: * a bit slow (we do not yet know the reason, may be unrelated to Zope) * occasionally surprising behavior Dieter

1 0

Problems with ZNavigator
by Ralf Kraemer 07 Mar '01

07 Mar '01

i would like to create a new instance of a ZNavigator product folder in the case of "infobar" is an existing instance from ZNavigator i can use the following and it works fine <dtml-with infobar> <dtml-call "manage_addNavigator(id='infobar',title=REQUEST.id,navlink=REQUEST.id,navico n=navicon,REQUEST=REQUEST)"> </dtml-with> but i would like to create a new instance of ZNavigator at a different place. "/seiten/" if i try i get the following error code Error Type: AttributeError Error Value: manage_addNavigator Traceback (innermost last): File /usr/local/lib/Zope-2.2.2-src/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /usr/local/lib/Zope-2.2.2-src/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/lib/Zope-2.2.2-src/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File /usr/local/lib/Zope-2.2.2-src/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/lib/Zope-2.2.2-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: MenuWizardForm) File /usr/local/lib/Zope-2.2.2-src/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: MenuWizardForm) File /usr/local/lib/Zope-2.2.2-src/lib/python/OFS/DTMLMethod.py, line 172, in __call__ (Object: MenuWizardForm) File /usr/local/lib/Zope-2.2.2-src/lib/python/DocumentTemplate/DT_String.py, line 528, in __call__ (Object: MenuWizardForm) File /usr/local/lib/Zope-2.2.2-src/lib/python/DocumentTemplate/DT_With.py, line 146, in render (Object: seiten) File /usr/local/lib/Zope-2.2.2-src/lib/python/DocumentTemplate/DT_Util.py, line 337, in eval (Object: seiten.manage_addNavigator(id='infobar',title=REQUEST.id,navlink=REQUEST.id, navicon=navicon,REQUEST=REQUEST)) (Info: seiten) File <string>, line 0, in ? File /usr/local/lib/Zope-2.2.2-src/lib/python/DocumentTemplate/DT_Util.py, line 129, in careful_getattr AttributeError: (see above) any suggestions ??? Ralf Kraemer

1 0

Structed Text weirdness
by Joel Burton 07 Mar '01

07 Mar '01

I've been teaching users to use Structured Text for their messages, but I've come across a few small annoyances: . Some items (like links) don't render if there isn't some text after them. If the very last part of an STX document is a link, it gets rendered as plain text. Added \n after will fix this. . Items that have 2 linefeeds after them are rendered as a heading, even if they are not intended to be. eg """ this is text """ comes out as a heading . you can't nest things in sensible ways: "**Visit my "site":http://www.site.org.** is in bold, but loses the link, whereas "**Visit my "site":http://www.site.org. ** isn't in bold (asterisks appear) I know STX is supposed to be a simple format, and I'm not advocated for complicating/changing the rules--but I find the behavior inconsistent w/expectations about how things should happen. Are there patches that fix these issues (I haven't seen any)? Are there workarounds? Is there a document ("advanced Structured Text") that I could point users to that would suggest workarounds for these problems. -- Joel Burton <jburton(a)scw.org> Director of Information Systems, Support Center of Washington

2 1