- Zope - Zope lists

Re: [Zope] SQLTEST is case insensitive?
by Dieter Maurer 09 Mar '01

09 Mar '01

The Doctor What writes: > * Dieter Maurer (dieter(a)handshake.de) [010307 16:39]: > > FThe Doctor What writes: > > > The problem is two fold: > > > 1) ID = 1 should be "ID" = 1 so that PostgreSQL will treat it as a > > > case sensitive string. > > This was discussed some time ago (--> list archives). > > Changing "dtml-sqltest" to enclose the column name in double quotes > > would break lots of code (as many people rely on the > > case insensitive interpretation). > > But consider. A feature is *missing* currently (the ability to use > sqltest and other dtml-sql* vars) with case sensitive databases. Only, if the database requires special syntax to make it case sensitive. > Would adding a toggle that says "Use double quotes" be a bad thing? I, personnaly, would not mind unless I had to use it in my code. > Frankly, I can't imagine anyone relying on having all their queries > dropped to lowercase. Why would someone, who avoided using cases > suddenly switch to throwing upper case characters into their sql > queries? It is the other way round! I designed the database and used mixed case names to improve readability. And my code originally used this same case as documented. But the database did not care about case. It converted silently all may mixed case names into upper case. Finally, I recognized this fact the hard way. I chased a tricky error for several hours to recognized it being caused by the database's upper casing. >From then on, my code used all upper case names. But I have colleagues... Some prefer all upper case, others all lower case, others mixed case ... If some demon would make "dtml-sqltext" (and friends) case sensitive, we would have to rework several hundred Z SQL methods. A nightmare... > .... > > You can use vanilla DTML to emulate "dtml-sqltest" > > like for example: > > > > .... > > "URL"."ID" = '<dtml-var ID sql_quote>' > > .... > > Thereby removing the whole benifit of using ZOPE and ZSQL objects. Why that? You would use the vanilla DTML inside the ZSQL *TEMPLATE*! You can use *ALL* DTML commands in a ZSQL template plus several special commands only available in these templates "dtml-sqlXXXX". Dieter

2 1

Thanks DC
by Andy McKay 09 Mar '01

09 Mar '01

Thanks to DC, especially Paul Everitt, for hosting the Zope Track at the Python Conference, for those who were lucky enough to attend I found it very informative, helpful and interesting. For those who couldnt go I hope everyone will be posting their presentations over the next few days. -- Andy McKay.

1 0

Free Beginner Zope class (Washington, DC) Apr 4
by Joel Burton 09 Mar '01

09 Mar '01

I direct a nonprofit technology program in Washington, DC, and we are training 5 VISTA/Americorps Volunteers for a year-long project. Part of what they will be doing is desiging database-backed web site for youth- and family-oriented nonprofits. Of course, we plan to use Zope. Anyway, I'll be teaching them some basics of Zope on April 4th. Covered topics will be: FTPing to Zope sites using the management interface creating new DTML docs / Images / external files basic Zope security basic DTML It's a beginner class, to be sure, but will be followed by more advanced instruction later. The class will probably be full-day, probably 9:30-4:30 w/lunch on your own. Like everything our org does, we try to make things open and free where we can, so if anyone would be interested in coming, please let me know. We have limited space in our lab (and already have 5 scheduled students!). I'm offering priority to nonprofit organizations first, but anyone that's interested should let me know. If anyone has any teaching materials for Zope, of course, I'd love to know about it. (I have a 9-seat computer lab. If anyone can offer anything larger in Washington, DC, I could probably manage a class up to 15 or 20.) HTH, -- Joel Burton <jburton(a)scw.org> Director of Information Systems, Support Center of Washington

1 0

What are you doing with Zope?
by D.Turpie＠open.ac.uk 08 Mar '01

08 Mar '01

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. I work with the Open University library in the UK and we are going to use Zope to pilot a small Intranet for library staff. Thanks. David.

4 3

RE: [Zope] RE: ZODBC problem (and ZmxODBC)
by Capesius, Alan 08 Mar '01

08 Mar '01

>From the Docs for ZmxODBCDA: Added experimental support for Unicode. This needs Python 2.0 (it should work with Python 1.6 too). To enable the Unicode support, compile the subpackages with -DWANT_UNICODE_SUPPORT. I don't have time to look into the 2.0 conversion and recompile of ZmxODBC so I'll live with the thing the way it is. My queries are all functioning at this point. >>>-----Original Message----- >>>From: Jzlio Dinis Silva [mailto:juliodinis@hotmail.com] >>>Sent: Thursday, March 08, 2001 5:03 PM >>>To: CapesiusA(a)Sysmex.com >>>Cc: zope(a)zope.org >>>Subject: RE: [Zope] RE: ZODBC problem (and ZmxODBC) >>> >>> >>>Hi, >>> >>>And there is also a Internal Error that happen when I do a >>>select to tables with a text datatype. Wether the text datatype >>>or maybe some internacional chars I have in this text fields, one >>>of this are also not supported by zmxodb. >>> >>>cia, >>>Julio Dinis Silva >>> >>> >>>>From: "Capesius, Alan" <CapesiusA(a)Sysmex.com> >>>>To: Jzlio Dinis Silva <juliodinis(a)hotmail.com> >>>>CC: zope(a)zope.org, mal(a)lemburg.com >>>>Subject: RE: [Zope] RE: ZODBC problem (and ZmxODBC) >>>>Date: Thu, 8 Mar 2001 15:35:59 -0600 >>>> >>>>OOPS. >>>> >>>>I do get the error. I apologize, I was looking at the wrong >>>ODBC_ link. >>>>ZmxODBC browser is failing as well for me. >>>> >>>>The problem is that ZmxODBC does not support the nvarchar data type >>>>(unicode >>>>varchar) in use in the Information_schema.columns table. >>>This could render >>>>ZmxODBCDA useless under certain conditions. >>>> >>>> >>>> >>>>An interesting aside: >>>>I use three queries to pull browse info from the tables >>>list. This is much >>>>faster than using the browser feature. Set the data source >>>to your ODBC >>>>source. >>>> >>>> >>>>Query 1 A_Table_Scan(search for all fieldnames containing >>>searchstring >>>> %__% wildcards OK): >>>>============================================================ >>>========== >>>>Arguments: search_sting >>>>SQL String: >>>>SELECT table_catalog,table_name,column_name,data_type FROM >>>>INFORMATION_SCHEMA.COLUMNS >>>>where column_name like <dtml-sqlvar search_string type=string> >>>>order by ordinal_position >>>> >>>>Query 2 A_Table_Structure (Show structure of selected table): >>>>============================================================ >>>========== >>>>Arguments: table >>>>SQL String: >>>>SELECT table_catalog,table_name,column_name,data_type FROM >>>>INFORMATION_SCHEMA.COLUMNS >>>>where table_name = <dtml-sqlvar table type=nb> >>>>order by ordinal_position >>>> >>>>Query 3 A_Tables (List tables): >>>>============================================================ >>>========== >>>>Arguments: NONE >>>>SQL String: >>>>SELECT * FROM INFORMATION_SCHEMA.TABLES >>>> >>>> >>>> >>>> >>>-----Original Message----- >>>> >>>From: Jzlio Dinis Silva [mailto:juliodinis@hotmail.com] >>>> >>>Sent: Thursday, March 08, 2001 2:46 PM >>>> >>>To: CapesiusA(a)Sysmex.com >>>> >>>Cc: zope(a)zope.org >>>> >>>Subject: RE: [Zope] RE: ZODBC problem (and ZmxODBC) >>>> >>> >>>> >>> >>>> >>>Hi >>>> >>> >>>> >>>I have the same versions but I still get the InterfaceError. >>>> >>> >>>> >>>I am able to create a table, insert some records and >>>> >>>query the table, but commands like sp_who or sp_tables, or >>>> >>>if I try to >>>> >>>view the "browse" tab I get an InterfaceError. >>>> >>> >>>> >>>Please confirm if the only changes you made was related >>>to moving >>>> >>>the mx directory to lib/python, and the rest was just like the >>>> >>>installations instructions said. >>>> >>> >>>> >>>Do you have the sqlserver7 on the same machine you have zope? >>>> >>> >>>> >>>Thanx, >>>> >>>Julio Dinis Silva >>>> >>> >>>> >>> >>>> >>>>From: "Capesius, Alan" <CapesiusA(a)Sysmex.com> >>>> >>>>To: Jzlio Dinis Silva <juliodinis(a)hotmail.com> >>>> >>>>Subject: RE: [Zope] RE: ZODBC problem (and ZmxODBC) >>>> >>>>Date: Thu, 8 Mar 2001 09:26:58 -0600 >>>> >>>> >>>> >>>>No problems with the browse tab here. >>>> >>>>I am running MDAC 2.5 drivers. >>>> >>>>Thats 3.70.08.20 for SQL Server. >>>> >>>>SQL is SQL7 SP2 >>>> >>>>And the ZmxODBC is 0.0.2 release. >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>-----Original Message----- >>>> >>>> >>>From: Jzlio Dinis Silva [mailto:juliodinis@hotmail.com] >>>> >>>> >>>Sent: Thursday, March 08, 2001 6:16 AM >>>> >>>> >>>To: CapesiusA(a)Sysmex.com >>>> >>>> >>>Cc: zope(a)zope.org >>>> >>>> >>>Subject: Re: [Zope] RE: ZODBC problem (and ZmxODBC) >>>> >>>> >>> >>>> >>>> >>> >>>> >>>> >>>Hi, >>>> >>>> >>> >>>> >>>> >>>I had some problems in the past using zmxodbcda and sql7. >>>> >>>> >>> >>>> >>>> >>>What version of sqlserver drivers are you using? >>>> >>>> >>> >>>> >>>> >>>If you click on the tab "browse" of your zmxodbda >>>connection >>>> >>>> >>>do you get a >>>> >>>> >>>InterfaceError? >>>> >>>> >>> >>>> >>>> >>>thanx, >>>> >>>> >>>Julio Dinis Silva >>>> >>>> >>> >>>> >>>> >>> >>>> >>>> >>>>From: "Capesius, Alan" <CapesiusA(a)Sysmex.com> >>>> >>>> >>>>To: bryanbz(a)2s2i.com >>>> >>>> >>>>CC: zope(a)zope.org >>>> >>>> >>>>Subject: [Zope] RE: ZODBC problem (and ZmxODBC) >>>> >>>> >>>>Date: Wed, 7 Mar 2001 17:49:09 -0600 >>>> >>>> >>>> >>>> >>>> >>>>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 ) >>>> >>>> >>>> >>> >>>> >>>> >>>> >>>> >>>> >>>>_______________________________________________ >>>> >>>> >>>>Zope maillist - Zope(a)zope.org >>>> >>>> >>>>http://lists.zope.org/mailman/listinfo/zope >>>> >>>> >>>>** No cross posts or HTML encoding! ** >>>> >>>> >>>>(Related lists - >>>> >>>> >>>> http://lists.zope.org/mailman/listinfo/zope-announce >>>> >>>> >>>> http://lists.zope.org/mailman/listinfo/zope-dev ) >>>> >>>> >>> >>>> >>>> >>>>>>_____________________________________________________________ >>>> >>>> >>>____________ >>>> >>>> >>>Get Your Private, Free E-mail from MSN Hotmail at >>>> >>>>http://www.hotmail.com. >>>> >>> >>>> >>>_____________________________________________________________ >>>> >>>____________ >>>> >>>Get Your Private, Free E-mail from MSN Hotmail at >>>>http://www.hotmail.com. >>>> >>>>_______________________________________________ >>>>Zope maillist - Zope(a)zope.org >>>>http://lists.zope.org/mailman/listinfo/zope >>>>** No cross posts or HTML encoding! ** >>>>(Related lists - >>>> http://lists.zope.org/mailman/listinfo/zope-announce >>>> http://lists.zope.org/mailman/listinfo/zope-dev ) >>> >>>_____________________________________________________________ >>>____________ >>>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

1 0

RE: [Zope] RE: ZODBC problem (and ZmxODBC)
by J�lio Dinis Silva 08 Mar '01

08 Mar '01

Hi, And there is also a Internal Error that happen when I do a select to tables with a text datatype. Wether the text datatype or maybe some internacional chars I have in this text fields, one of this are also not supported by zmxodb. cia, Julio Dinis Silva >From: "Capesius, Alan" <CapesiusA(a)Sysmex.com> >To: Jzlio Dinis Silva <juliodinis(a)hotmail.com> >CC: zope(a)zope.org, mal(a)lemburg.com >Subject: RE: [Zope] RE: ZODBC problem (and ZmxODBC) >Date: Thu, 8 Mar 2001 15:35:59 -0600 > >OOPS. > >I do get the error. I apologize, I was looking at the wrong ODBC_ link. >ZmxODBC browser is failing as well for me. > >The problem is that ZmxODBC does not support the nvarchar data type >(unicode >varchar) in use in the Information_schema.columns table. This could render >ZmxODBCDA useless under certain conditions. > > > >An interesting aside: >I use three queries to pull browse info from the tables list. This is much >faster than using the browser feature. Set the data source to your ODBC >source. > > >Query 1 A_Table_Scan(search for all fieldnames containing searchstring > %__% wildcards OK): >====================================================================== >Arguments: search_sting >SQL String: >SELECT table_catalog,table_name,column_name,data_type FROM >INFORMATION_SCHEMA.COLUMNS >where column_name like <dtml-sqlvar search_string type=string> >order by ordinal_position > >Query 2 A_Table_Structure (Show structure of selected table): >====================================================================== >Arguments: table >SQL String: >SELECT table_catalog,table_name,column_name,data_type FROM >INFORMATION_SCHEMA.COLUMNS >where table_name = <dtml-sqlvar table type=nb> >order by ordinal_position > >Query 3 A_Tables (List tables): >====================================================================== >Arguments: NONE >SQL String: >SELECT * FROM INFORMATION_SCHEMA.TABLES > > > > >>>-----Original Message----- > >>>From: Jzlio Dinis Silva [mailto:juliodinis@hotmail.com] > >>>Sent: Thursday, March 08, 2001 2:46 PM > >>>To: CapesiusA(a)Sysmex.com > >>>Cc: zope(a)zope.org > >>>Subject: RE: [Zope] RE: ZODBC problem (and ZmxODBC) > >>> > >>> > >>>Hi > >>> > >>>I have the same versions but I still get the InterfaceError. > >>> > >>>I am able to create a table, insert some records and > >>>query the table, but commands like sp_who or sp_tables, or > >>>if I try to > >>>view the "browse" tab I get an InterfaceError. > >>> > >>>Please confirm if the only changes you made was related to moving > >>>the mx directory to lib/python, and the rest was just like the > >>>installations instructions said. > >>> > >>>Do you have the sqlserver7 on the same machine you have zope? > >>> > >>>Thanx, > >>>Julio Dinis Silva > >>> > >>> > >>>>From: "Capesius, Alan" <CapesiusA(a)Sysmex.com> > >>>>To: Jzlio Dinis Silva <juliodinis(a)hotmail.com> > >>>>Subject: RE: [Zope] RE: ZODBC problem (and ZmxODBC) > >>>>Date: Thu, 8 Mar 2001 09:26:58 -0600 > >>>> > >>>>No problems with the browse tab here. > >>>>I am running MDAC 2.5 drivers. > >>>>Thats 3.70.08.20 for SQL Server. > >>>>SQL is SQL7 SP2 > >>>>And the ZmxODBC is 0.0.2 release. > >>>> > >>>> > >>>> > >>>> >>>-----Original Message----- > >>>> >>>From: Jzlio Dinis Silva [mailto:juliodinis@hotmail.com] > >>>> >>>Sent: Thursday, March 08, 2001 6:16 AM > >>>> >>>To: CapesiusA(a)Sysmex.com > >>>> >>>Cc: zope(a)zope.org > >>>> >>>Subject: Re: [Zope] RE: ZODBC problem (and ZmxODBC) > >>>> >>> > >>>> >>> > >>>> >>>Hi, > >>>> >>> > >>>> >>>I had some problems in the past using zmxodbcda and sql7. > >>>> >>> > >>>> >>>What version of sqlserver drivers are you using? > >>>> >>> > >>>> >>>If you click on the tab "browse" of your zmxodbda connection > >>>> >>>do you get a > >>>> >>>InterfaceError? > >>>> >>> > >>>> >>>thanx, > >>>> >>>Julio Dinis Silva > >>>> >>> > >>>> >>> > >>>> >>>>From: "Capesius, Alan" <CapesiusA(a)Sysmex.com> > >>>> >>>>To: bryanbz(a)2s2i.com > >>>> >>>>CC: zope(a)zope.org > >>>> >>>>Subject: [Zope] RE: ZODBC problem (and ZmxODBC) > >>>> >>>>Date: Wed, 7 Mar 2001 17:49:09 -0600 > >>>> >>>> > >>>> >>>>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 ) > >>>> >>>> >>> > >>>> >>>> > >>>> >>>>_______________________________________________ > >>>> >>>>Zope maillist - Zope(a)zope.org > >>>> >>>>http://lists.zope.org/mailman/listinfo/zope > >>>> >>>>** No cross posts or HTML encoding! ** > >>>> >>>>(Related lists - > >>>> >>>> http://lists.zope.org/mailman/listinfo/zope-announce > >>>> >>>> http://lists.zope.org/mailman/listinfo/zope-dev ) > >>>> >>> > >>>> >>>_____________________________________________________________ > >>>> >>>____________ > >>>> >>>Get Your Private, Free E-mail from MSN Hotmail at > >>>>http://www.hotmail.com. > >>> > >>>_____________________________________________________________ > >>>____________ > >>>Get Your Private, Free E-mail from MSN Hotmail at >http://www.hotmail.com. > >_______________________________________________ >Zope maillist - Zope(a)zope.org >http://lists.zope.org/mailman/listinfo/zope >** No cross posts or HTML encoding! ** >(Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

1 0

Re: [Zope] IPC 9 News?
by Luke Tymowski 08 Mar '01

08 Mar '01

Hello Chris, > I was wondering if anyone had any cool news from the Zope track at IPC 9 for > those of us who can't make it? Jeff of ZopeNewbies has been covering the Zope track for the past couple of days: http://weblogs.userland.com/zopenewbies/ O'Reilly has had some coverage as well, but not nearly as Zope-specific as Jeff's coverage. From O'Reilly we learn that O'Reilly will have a Zope book later this year, a more advanced book that teaches Zope by way of building an application. http://python.oreilly.com/news/pythonday2_0301.html This means 3 Zope books: two with New Riders and one from O'Reilly. Luke

1 0

RE: [Zope] RE: ZODBC problem (and ZmxODBC)
by Capesius, Alan 08 Mar '01

08 Mar '01

OOPS. I do get the error. I apologize, I was looking at the wrong ODBC_ link. ZmxODBC browser is failing as well for me. The problem is that ZmxODBC does not support the nvarchar data type (unicode varchar) in use in the Information_schema.columns table. This could render ZmxODBCDA useless under certain conditions. An interesting aside: I use three queries to pull browse info from the tables list. This is much faster than using the browser feature. Set the data source to your ODBC source. Query 1 A_Table_Scan(search for all fieldnames containing searchstring %__% wildcards OK): ====================================================================== Arguments: search_sting SQL String: SELECT table_catalog,table_name,column_name,data_type FROM INFORMATION_SCHEMA.COLUMNS where column_name like <dtml-sqlvar search_string type=string> order by ordinal_position Query 2 A_Table_Structure (Show structure of selected table): ====================================================================== Arguments: table SQL String: SELECT table_catalog,table_name,column_name,data_type FROM INFORMATION_SCHEMA.COLUMNS where table_name = <dtml-sqlvar table type=nb> order by ordinal_position Query 3 A_Tables (List tables): ====================================================================== Arguments: NONE SQL String: SELECT * FROM INFORMATION_SCHEMA.TABLES >>>-----Original Message----- >>>From: Jzlio Dinis Silva [mailto:juliodinis@hotmail.com] >>>Sent: Thursday, March 08, 2001 2:46 PM >>>To: CapesiusA(a)Sysmex.com >>>Cc: zope(a)zope.org >>>Subject: RE: [Zope] RE: ZODBC problem (and ZmxODBC) >>> >>> >>>Hi >>> >>>I have the same versions but I still get the InterfaceError. >>> >>>I am able to create a table, insert some records and >>>query the table, but commands like sp_who or sp_tables, or >>>if I try to >>>view the "browse" tab I get an InterfaceError. >>> >>>Please confirm if the only changes you made was related to moving >>>the mx directory to lib/python, and the rest was just like the >>>installations instructions said. >>> >>>Do you have the sqlserver7 on the same machine you have zope? >>> >>>Thanx, >>>Julio Dinis Silva >>> >>> >>>>From: "Capesius, Alan" <CapesiusA(a)Sysmex.com> >>>>To: Jzlio Dinis Silva <juliodinis(a)hotmail.com> >>>>Subject: RE: [Zope] RE: ZODBC problem (and ZmxODBC) >>>>Date: Thu, 8 Mar 2001 09:26:58 -0600 >>>> >>>>No problems with the browse tab here. >>>>I am running MDAC 2.5 drivers. >>>>Thats 3.70.08.20 for SQL Server. >>>>SQL is SQL7 SP2 >>>>And the ZmxODBC is 0.0.2 release. >>>> >>>> >>>> >>>> >>>-----Original Message----- >>>> >>>From: Jzlio Dinis Silva [mailto:juliodinis@hotmail.com] >>>> >>>Sent: Thursday, March 08, 2001 6:16 AM >>>> >>>To: CapesiusA(a)Sysmex.com >>>> >>>Cc: zope(a)zope.org >>>> >>>Subject: Re: [Zope] RE: ZODBC problem (and ZmxODBC) >>>> >>> >>>> >>> >>>> >>>Hi, >>>> >>> >>>> >>>I had some problems in the past using zmxodbcda and sql7. >>>> >>> >>>> >>>What version of sqlserver drivers are you using? >>>> >>> >>>> >>>If you click on the tab "browse" of your zmxodbda connection >>>> >>>do you get a >>>> >>>InterfaceError? >>>> >>> >>>> >>>thanx, >>>> >>>Julio Dinis Silva >>>> >>> >>>> >>> >>>> >>>>From: "Capesius, Alan" <CapesiusA(a)Sysmex.com> >>>> >>>>To: bryanbz(a)2s2i.com >>>> >>>>CC: zope(a)zope.org >>>> >>>>Subject: [Zope] RE: ZODBC problem (and ZmxODBC) >>>> >>>>Date: Wed, 7 Mar 2001 17:49:09 -0600 >>>> >>>> >>>> >>>>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 ) >>>> >>>> >>> >>>> >>>> >>>> >>>>_______________________________________________ >>>> >>>>Zope maillist - Zope(a)zope.org >>>> >>>>http://lists.zope.org/mailman/listinfo/zope >>>> >>>>** No cross posts or HTML encoding! ** >>>> >>>>(Related lists - >>>> >>>> http://lists.zope.org/mailman/listinfo/zope-announce >>>> >>>> http://lists.zope.org/mailman/listinfo/zope-dev ) >>>> >>> >>>> >>>_____________________________________________________________ >>>> >>>____________ >>>> >>>Get Your Private, Free E-mail from MSN Hotmail at >>>>http://www.hotmail.com. >>> >>>_____________________________________________________________ >>>____________ >>>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

1 0

RE: [Zope] RE: ZODBC problem (and ZmxODBC)
by J�lio Dinis Silva 08 Mar '01

08 Mar '01

Does anyone have ZmxOdbc working with sql7.0 sp1, i.e, can see the "browse" tab without a InterfaceError? Thanx, Julio Dinis Silva >From: "Capesius, Alan" <CapesiusA(a)Sysmex.com> >To: Jzlio Dinis Silva <juliodinis(a)hotmail.com> >Subject: RE: [Zope] RE: ZODBC problem (and ZmxODBC) >Date: Thu, 8 Mar 2001 09:26:58 -0600 > >No problems with the browse tab here. >I am running MDAC 2.5 drivers. >Thats 3.70.08.20 for SQL Server. >SQL is SQL7 SP2 >And the ZmxODBC is 0.0.2 release. > > > > >>>-----Original Message----- > >>>From: Jzlio Dinis Silva [mailto:juliodinis@hotmail.com] > >>>Sent: Thursday, March 08, 2001 6:16 AM > >>>To: CapesiusA(a)Sysmex.com > >>>Cc: zope(a)zope.org > >>>Subject: Re: [Zope] RE: ZODBC problem (and ZmxODBC) > >>> > >>> > >>>Hi, > >>> > >>>I had some problems in the past using zmxodbcda and sql7. > >>> > >>>What version of sqlserver drivers are you using? > >>> > >>>If you click on the tab "browse" of your zmxodbda connection > >>>do you get a > >>>InterfaceError? > >>> > >>>thanx, > >>>Julio Dinis Silva > >>> > >>> > >>>>From: "Capesius, Alan" <CapesiusA(a)Sysmex.com> > >>>>To: bryanbz(a)2s2i.com > >>>>CC: zope(a)zope.org > >>>>Subject: [Zope] RE: ZODBC problem (and ZmxODBC) > >>>>Date: Wed, 7 Mar 2001 17:49:09 -0600 > >>>> > >>>>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 ) > >>>> >>> > >>>> > >>>>_______________________________________________ > >>>>Zope maillist - Zope(a)zope.org > >>>>http://lists.zope.org/mailman/listinfo/zope > >>>>** No cross posts or HTML encoding! ** > >>>>(Related lists - > >>>> http://lists.zope.org/mailman/listinfo/zope-announce > >>>> http://lists.zope.org/mailman/listinfo/zope-dev ) > >>> > >>>_____________________________________________________________ > >>>____________ > >>>Get Your Private, Free E-mail from MSN Hotmail at >http://www.hotmail.com. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

1 0

RE: [Zope] Telnet to Port 8080
by Farrell, Troy 08 Mar '01

08 Mar '01

Please let us know exactly what you are typing. Your request may be flawed, or you might not be allowed to connect (IPCHAINS) Troy -----Original Message----- From: karthick ramanarayanan [mailto:karthick@pepco.no] Sent: Thursday, March 08, 2001 2:42 PM To: zope(a)zope.org Subject: [Zope] Telnet to Port 8080 Why Am I not able to telnet to port 8080 and do a , GET / like you do on port 80. It just hangs. Whats the problem. Bye, A.R.Karthick _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

1 0