Re: [Zope] is it possible to see whether any user is using a perticular zope object
Okay, firstup, keep CC:'ing zope@zope.org so other people can help, and so other people can _get_ help from any answers you find... subrahmanyan kalathur wrote:
so now I am getting the error.
What is this error? (the lines starting with 'traceback:' are really useful...)
what is that ZEO and all.
It's probably best you don't go there for a while ;-) cheers, Chris
hi, when I use the DTML method which include call to SQL methods, if someone is also using that DTML Method then either of us get the error message. And the error message is as follows. Error Type: SyntaxError Error Value: unexpected token sequence.near :: "\012Q_name = 'q24'"*'' ******************************* current state = 231 expects: 'EXCEPT', '+', ')', 'HAVING', '-', 'UNION', 'AND', 'GROUP', '*', ';', 'OR', 'ORDER', 'INTERSECT', ('nomatch1',) current token = ((-6, 'WHERE'), 'WHERE') I would like to avoid that error, instead of that I would like say 'wait ' or something like that. and after the first one gets the complete page the other's page should come. Can u give any suggestions. thanks bye yours, K.H.Subrahmanyan ( subrahmanyan.kalathur@wipro.com )
subrahmanyan kalathur wrote:
Error Type: SyntaxError Error Value: unexpected token sequence.near :: "\012Q_name = 'q24'"*'' ******************************* current state = 231 expects: 'EXCEPT', '+', ')', 'HAVING', '-', 'UNION', 'AND', 'GROUP', '*', ';', 'OR', 'ORDER', 'INTERSECT', ('nomatch1',) current token = ((-6, 'WHERE'), 'WHERE')
It sounds more likely that your SQL has problems. Perhaps you could post your ZSQL method to the list? (but only if it's shorter than 20 lines long! ;-) What dabatase are you using? What database adapter? What versions? cheers, Chris
hi I am n using gadfly database. This is not the problem of ZSQL method.(I think) Because when only one user is working there won't be any problem. It seems like when more than one users access the same table it gives the error message. That is why when more than one users try to access the same DTML method only one will be able to continue , others will get the error message. thanks yours, K.H.Subrahmanyan ( subrahmanyan.kalathur@wipro.com )
subrahmanyan kalathur wrote:
I am n using gadfly database.
That'll be your problem. It's not exactly the most robust database in the world... You problems will go away if you move to MySQL, PostGres, Oracle, etc... or stop using RDBMS'es altogether... cheers, Chris
Chris Withers wrote:
subrahmanyan kalathur wrote:
I am n using gadfly database.
That'll be your problem. It's not exactly the most robust database in the world...
You problems will go away if you move to MySQL, PostGres, Oracle, etc... or stop using RDBMS'es altogether...
I agree. Unless there is a compelling reason, such as sharing tables with another application. Why not just use ZODB. Life can't be simplier! <g> -- Tim Cook, President -- Free Practice Management,Inc. | http://FreePM.com Office: (901) 884-4126 Censorship: The reaction of the ignorant to freedom.
Tim Cook <twcook@iswt.com> said:
You problems will go away if you move to MySQL, PostGres, Oracle, etc... or stop using RDBMS'es altogether...
I agree. Unless there is a compelling reason, such as sharing tables with another application. Why not just use ZODB. Life can't be simplier! <g>
Will life stay simple (robust, performant) after you've dumped a couple of hundredthousand records into ZODB? I find using mySQL a PITA compared to ZODB, but I'm not sure how well it keeps with lots of data... -- Cees de Groot http://www.cdegroot.com <cg@cdegroot.com> GnuPG 1024D/E0989E8B 0016 F679 F38D 5946 4ECD 1986 F303 937F E098 9E8B
Cees de Groot wrote:
Tim Cook <twcook@iswt.com> said:
You problems will go away if you move to MySQL, PostGres, Oracle, etc... or stop using RDBMS'es altogether...
I agree. Unless there is a compelling reason, such as sharing tables with another application. Why not just use ZODB. Life can't be simplier! <g>
Will life stay simple (robust, performant) after you've dumped a couple of hundredthousand records into ZODB? I find using mySQL a PITA compared to ZODB, but I'm not sure how well it keeps with lots of data...
Shane Hathaway mentioned having a ZODB that was happily running at 11GB, that's a lot of data in my books ;-) cheers, Chris
On Wed, 22 Nov 2000, Chris Withers wrote:
Cees de Groot wrote:
Tim Cook <twcook@iswt.com> said:
You problems will go away if you move to MySQL, PostGres, Oracle, etc... or stop using RDBMS'es altogether...
I agree. Unless there is a compelling reason, such as sharing tables with another application. Why not just use ZODB. Life can't be simplier! <g>
Will life stay simple (robust, performant) after you've dumped a couple of hundredthousand records into ZODB? I find using mySQL a PITA compared to ZODB, but I'm not sure how well it keeps with lots of data...
Shane Hathaway mentioned having a ZODB that was happily running at 11GB, that's a lot of data in my books ;-)
Quickly question then... How would you record data in the ZODB? Would you have to write a Product for each thing you want to store? If you can provide some links it would be great! Thanks, -- ...EAM... edwardam@home.com edwardam@handhelds.org ----------------------- 'It's because crappy programs offend me.' --Eric Raymond Grow a ponytail -- view it as your telepathic antenna to other Linux Kernel Developers. -- Jeff V. Merkey
Edward Muller wrote:
How would you record data in the ZODB? Would you have to write a Product for each thing you want to store? If you can provide some links it would be great!
Well, HiperDom's XML templates product apparently contains some data object thing which might do the job: http://www.zope.org/Members/lalo/HiperDom Otherwise, start with the Boring product and build what you need: http://www.zope.org/Members/gtk/Boring http://www.zope.org/Members/hathawsh/PythonProductTutorial Good luck, Chris
Have you tried using any other dbms to alleviate the problem. ----- Original Message ----- From: "subrahmanyan kalathur" <subrahmanyan.kalathur@wipro.com> To: "Chris Withers" <chrisw@nipltd.com> Cc: <zope@zope.org> Sent: Wednesday, November 22, 2000 11:03 AM Subject: Re: [Zope] is it possible to see whether any user is using a perticular zope object
hi I am n using gadfly database. This is not the problem of ZSQL method.(I think) Because when only one user is working there won't be any problem. It seems like when more than one users access the same table it gives the error message. That is why when more than one users try to access the same DTML method only one will be able to continue , others will get the error message.
thanks
yours,
K.H.Subrahmanyan
( subrahmanyan.kalathur@wipro.com )
_______________________________________________ Zope maillist - Zope@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 )
No, I haven't used any other DBMS. I have almost finished working in this gadfly. So I can't change now. Because there is no time to change it now. So please give me the solution. thanks yours, K.H.Subrahmanyan ( subrahmanyan.kalathur@wipro.com )
subrahmanyan kalathur wrote:
I haven't used any other DBMS. I have almost finished working in this gadfly. So I can't change now. Because there is no time to change it now. So please give me the solution.
IIRC (and I'm sure someone will tell me if I don't) Gadfly is single threaded, hence your problem. So, the solution, I'm afraid, is to use a different RDBMS... chers, Chris
In reality changing the dbms shouldn't cause too many problems (I'd give it a day to get the conversion done myself). Try MySQL or Interbase as they work fine on Win32 (which if I remember correctly is what you use?) Phil ----- Original Message ----- From: "subrahmanyan kalathur" <subrahmanyan.kalathur@wipro.com> To: "Phil Harris" <phil.harris@zope.co.uk>; "Chris Withers" <chrisw@nipltd.com> Cc: <zope@zope.org> Sent: Wednesday, November 22, 2000 11:36 AM Subject: Re: [Zope] is it possible to see whether any user is using a perticular zope object
No, I haven't used any other DBMS. I have almost finished working in this gadfly. So I can't change now. Because there is no time to change it now. So please give me the solution. thanks
yours,
K.H.Subrahmanyan
( subrahmanyan.kalathur@wipro.com )
Hi, Same as you, i tried to use this gadfly thing when I started and even when choosing it I received a message from zope telling me that it wasn't the real thing/unreliable/etc. I *think* there is a more stable GadFly somewhere but I would advise you to go with mySQL which I use and never had any problems with. Unless I'm wrong, it wouldn't be such a pain to change to mySQL or other DBMS... You would only have to dump the content of the current DB and create the tables, if necessary. mySQL's learning curve is not that big and is faily easy to understand/use/get used to. HTH Dany -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of subrahmanyan kalathur Sent: Wednesday, November 22, 2000 7:36 AM To: Phil Harris; Chris Withers Cc: zope@zope.org Subject: Re: [Zope] is it possible to see whether any user is using a perticular zope object No, I haven't used any other DBMS. I have almost finished working in this gadfly. So I can't change now. Because there is no time to change it now. So please give me the solution. thanks yours, K.H.Subrahmanyan ( subrahmanyan.kalathur@wipro.com ) _______________________________________________ Zope maillist - Zope@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 )
participants (8)
-
cg＠cdegroot.com -
Chris Withers -
Chris Withers -
Dany Rioux -
Edward Muller -
Phil Harris -
subrahmanyan kalathur -
Tim Cook