Re: [Zope] Re: Problem with keep-alive timeout
On Thursday 23 June 2005 19:33, Dieter Maurer - [EMAIL PROTECTED] wrote: It has nothing to do with a request timeout! So whats the reason that this f***ing browser using HTTP1.0? Zope understands large parts of HTTP 1.1, among others the Keep-Alive header, but it is not fully HTTP 1.1 compliant. Therefore, it uses HTTP 1.0 in its responses. That's probably the reason why your browser uses HTTP 1.0 for its requests... Ok as I understand, my solution to wait on a database report is not the best, because HTTP in general isn't designed to hold connections over a long time. But what could be a solution for such a problem? Writing the report values with a sessionid in the database, while the is looking at a page with an reload metatag until I have the results? Or writing code to store a values in a session? This is needing a lot of work and the resulting structure will be getting ugly. Is there a class or something else to make it easier? Btw. I'm using PostgreSQL with zpsycopgda 1.15 and Zope2.80, a very basic interface. I tried psycopg 2.00B3 but this version had problems with testing in the databaseadapter, so I decided to go back to 1.15. The hole databaselayer in Zope is very basic, you have to take care about things, that should be a part of a module. I.e. it could be a great thing to put in a databasedefinition plus handlingdefinition to get out a complete set of pages, including checks on fields. I'm worked in 1991 at a company that had a DB-RAD-System called Unique4GL (from Norway) that worked in a such manner with the output on a terminal. Since then I had never find a similar system. You had to describe the screen and the part of the used databasestructure and this was all. 1:n and join relations to display it on one screen regarding all constraints took not more then 10min. Could it be possible to make such a system with Zope, based on the logic of HTTP? ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: Problem with keep-alive timeout (zope: addressed to exclusive (zope: addressed to exclusive sender for this address) sender for this address)
On Tuesday 21 June 2005 23:28, Tres Seaver - [EMAIL PROTECTED] wrote: No that's not possible with HTTP1.0. The problem is, why IE is using HTTP1.0? With HTTP1.1 its possible to change keepalive-timeout. 'keepalive' only refers to the lenght of time that the browser-webserver connection stays open between the completion of one request and the beginning of another to the same server. The behavior we are discussing here is that IE (or sometimes Apache in the middle) is configured to time out a single request after a period of time; Mozilla and derived browsers don't do that by default. MS says: By default, HTTP 1.1 is enabled in Internet Explorer except when you establish an HTTP connection through a proxy server. When HTTP 1.1 is enabled, HTTP connections remain open (or persistent) by default until the connection is idle for one minute or until the value that is specified by the KeepAliveTimeout value in the registry is reached. You can modify HTTP 1.1 settings in Internet Explorer by using the Advanced tab in the Internet Options dialog box.(http://support.microsoft.com/default.aspx?kbid=813827) I interpret this so: You have to use HTTP1.1 . So whats the reason that this f***ing browser using HTTP1.0? ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Problem with keep-alive timeout (zope: addressed to exclusive sender for this address)
On Tuesday 21 June 2005 19:16, Dieter Maurer - [EMAIL PROTECTED] wrote: Ralph wrote at 2005-6-20 22:36 +0200: The easiest way would be to use a different browser ;-) I think IE can be customized to use a different timeout (I do not know as I use Mozilla -- by default without timeout). No that's not possible with HTTP1.0. The problem is, why IE is using HTTP1.0? With HTTP1.1 its possible to change keepalive-timeout. ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Problem with keep-alive timeout
I made a small and simple database applikation with some reports on a large database. But surprise, IE 6.0 (WinXP,SP2) is getting always a timeout after 60seconds, because IE communicates with Zope through the HTTP1.0-protocoll. My reports needing always 40s-120s, so is there someone that could give me a solution for this annoying timeout problem? ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Zope programms for databases
I'm new to Zope and made a small database application with zope (mostly DTML) to learn the idea behind Zope, but I'm not satisfied with the structure of my application. I have for each table a Form (DTML-method) with 3 buttons (new,update,delete). Each button triggers a DTML-script actionTable actionTable calls either a DTML-method to display a form (update, insert) or calling the zsql-method to delete a data record. The disadvantage with this structure is, that it is difficult to maintain programs like this. I wish to have optimistic locking but to send variables to the next DTML-method is a hell. Example: I you have a database table with the rows id,name and desc I have to send all record values through all methods after the user is triggering update to secure that there is no concurrent update. But with my design approach it's not possible. Is there someone who has a better design approach or an idea? ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Problem with namespace (zope: addressed to exclusive sender for this address)
On Thursday 16 June 2005 19:24, Dieter Maurer - [EMAIL PROTECTED] wrote: Ralph wrote at 2005-6-15 20:59 +0200: For details, please the the Calling DTML objects section in Thank you for the answer. It was a simple programming failure, after 12h of working. ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Problem with namespace
I have these objects: A is calling B is calling (D and E) My directory layout is: /map/ /map/sql /map/util /map/report/report1 /map/report/report2 /map/report/report3 Method A in report1 is rendering B in util. B is rendering a ZSQL-object in sql and in the tag dtml-in is rendering C (python-method) in util, to render a table cell, but this isn't working, because E is unknown and I don't know why. Example: DTML-Method A: dtml-in sql.list_mytable prefix=pre dtml-var util.B(index=pre_index) /dtml-in DTML-Method B td dtml-var expr=C(index=index) /td Here is Zope breaking because Zope can't find method C. Could someone help? Ralph ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
RE: [Zope] Does anyone care whether we deprecate ZClasses?
SOS This would mean a disaster for us. We've created a lot products using ZClasses in production environment (internet,intranet,eai and so on) since zope-2.1.4. In short our complete developement in Zope is heavily based on ZClasses. We plan to use ZClasses in the future, too. For us ZClasses are a essential part of zope and they works very well. It is quite impossible for us to migrate all our Products to python-products or somethong else and i guess that this is not wanted by you!? I think that going away from ZClasses will let many other people with legacy-software running in the same problems. regards ralph ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Re:[SybDA]Connection : how does it work ?
Hi, Which Zope version are you using? V 2.2.0 had a bug with the connection of the DB. I just looked into V 2.2.4 and the problematic code seems to be fixed although I've not tried this version yet. Maybe you should upgrade. If this is not the case, then ... hmm no idea. Ralph On Fri, 24 Nov 2000, you wrote: Hello, I am running Zope 2.1.6 under Linux/RH6.2 on a PC. The Sybase server is version 11.9.2 on a Solaris station with DNS name "sybstat" on port 2040 (or sybase server name "sybtest") and the database is named "picsou". When I try filling in the form to add a new Sybase DA connection, the result is always: Invalid connection string. I have try with this parameters : 1-database: picsou, password: mypasswd, server: sybstat, user: myuser 2-database: picsou, password: mypasswd, server: sybstat:2040, user: myuser But this give the same answer ... On Linux, I have the libraries, include files and all running client for Sybase and I can run isql from my PC on the Sybase server on the solaris station very well using the parameters of the (2-) set. So the connection to the Sybase server seems to work ... How could I check what happens inside Zope, or am I mistaken for the parameters values ? Thanks for any help. Tony ___ Zope maillist - [EMAIL PROTECTED] 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 ) -- -- Ralph Heinkel Cenix Bioscience GmbH Director of the IT-UnitTel : +49 6221/387 915 Meyerhofstr. 1 Fax : +49 6221/387 971 69117 Heidelberg, Germany eMail: [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Sybase (again?)
Hi, We are using Zope 2.1.6, Sybase 11.9.2, Sybase DA 2.00b2 on Suse Linux 6.4 and 7.0, stored procedures just work fine. Zope 2.2.x has a problem with Sybase, a patch has been submitted and should come with the next release. Ralph On Fri, 10 Nov 2000, Chris McDonough wrote: SybaseDA AFAIK does not support stored procedures. "Manuel Amador (Rudd-O)" wrote: Well, After no one else answered my last email about zope, I've decided to summarize what's going on with the ZSybaseDA so as to see if someone takes interest. STORED PROCEDURES DO NOT WORK. Anything else, however, does. Once a stored procedure was called, the db object is blocked till zope restarts. Any patches, solutions, suggestions? Manuel -- Chris McDonough Digital Creations, Publishers of Zope http://www.zope.org -- -- Ralph Heinkel Cenix Bioscience GmbH Director of the IT-UnitTel : +49 6221/387 915 Meyerhofstr. 1 Fax : +49 6221/387 971 69117 Heidelberg, Germany eMail: [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Zope and Sybase Stored Procedures
Hi, we are using Zope 2.1.6 with Sybase 11.9.2 on Suse Linux, and calling stored procedures just works fine. e.g. create procedure csp_add_barcode @tableName varchar(12), @barcode numeric(8) OUT AS insert into BarcodeItem (tableName) values (@tableName) select @barcode = @@identity This is a stored procedure that inserts one row into the table 'BarcodeItem' and returns an automatically created unique identity key as a result named 'barcode'. The ZSQL methods takes one parameter 'tableName' and returns the resulting 'barcode' like a normal select statement does. The query template simply is: csp_add_barcode dtml-sqlvar tableName type=string Hope that helps. Btw, Zope 2.2.0 has a bug in connecting to SybaseDA which is reported to digicool. Should be fixed in the next release. If interested for the fix, send me a mail. Ralph -- Ralph Heinkel Cenix Bioscience GmbH Director of the IT-UnitTel : +49 6221/387 915 Meyerhofstr. 1 Fax : +49 6221/387 971 69117 Heidelberg, Germany eMail: [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] SybaseDA and ASA
On Thu, 12 Oct 2000, you wrote: I've installed zope 2.2.2, and compiled sy_occ.so for SybaseDA against sybase-common-cantrememberversion.rpm from Sybase. (I assume it's the latest one). Loading python and importing sy_occ works perfectly. BUT, I can't create a SybaseDA SQL connection object . Specifically, trying to create it sez connection failed. I've tried EVERY POSSIBLE parameter combination on the creation form. None worked. By the way, I'm using Adaptive Server Anywhere for linux, 6.0.3. It is NOT ASE. It is ASA. Does sy_occ work with ASA, or only with ASE? Any experiences? Last week I was trying to upgrade from Zope V 2.1.6 (with working sybase adapter) to a 2.2.x version, and my sybase adapter stop working (yes I recompiled it). We are using ASE 11.9.2 on a linux box. Seems like Zope has introduced some incompatibilities which no one has discovered so far. Ralph -- Ralph Heinkel Cenix Bioscience GmbH Director of the IT-UnitTel : +49 6221/387 915 Meyerhofstr. 1 Fax : +49 6221/387 971 69117 Heidelberg, Germany eMail: [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Integers in ZSQLMethod
On Wed, 04 Oct 2000, you wrote: Hi, Is it possible to use following code in ZSQLMethod : !--#sqlvar NMRSEQS.PAR_FLIPANGLE type=int --, But also allow null as value for the integer? (Thus not filled in) use !--#sqlvar NMRSEQS.PAR_FLIPANGLE type=int optional-- or the newer syntax dtml-sqlvar MRSEQS.PAR_FLIPANGLE type=int optional Ralph -- Ralph Heinkel Cenix Bioscience GmbH Director of the IT-UnitTel : +49 6221/387 915 Meyerhofstr. 1 Fax : +49 6221/387 971 69117 Heidelberg, Germany eMail: [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] howto force rendering of a dtml doc
Hi, having a structure like FolderA DocA FolderB DocB I try to display DocA from within DocB using dtml-var "FolderA.DocA" which basically works, except that HTML code from DocA is not rendered but printed as plain ascii (e.g. I can see the br statements as these 4 characters). Is there a way to force rendering? Thanks, Ralph -- -- Ralph Heinkel MPI-CBG, Group Echeverri Meyerhofstr. 1 69012 Heidelberg Tel. 06221/387 915 Fax. 06221/387 971 eMail: [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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 )
