April 2000 - Zope-Dev

ADO Database Connections
by Theodore Patrick 25 Apr '00

25 Apr '00

Has anyone done any work in making database connections via ADO/OLEDB or JDBC in JAVA? I do not know what would be involved but there has been allot of work in this area from a performance standpoint. Both JDBC and ADO are widely supported on many platforms and both provide native database functionality via native drivers. Is there a way for ZOPE to utilize ADO/OLDB or JDBC via a python component (maybe implemented as LOCAL STORAGE(ZEO))? Is there a way to provide Database Connection Pooling (add/remove DB connections based on application usage?) Lack of support for Native database functionality in ZOPE is a major drawback and getting every DB vendor to code Python Drivers for ZOPE doesn't seem reasonable from a maintenance standpoint on both sides of the coin(developer/database manufacturer). Coding a DB connection manager to an "DB DRIVER standard"(I use the term loosely) would provide better long term support and flexibility. Any thoughts? Thanks in advance. Theodore E. Patrick Indigo Networks - Ishophere.com

1 0

Found what caused Zope to spin out
by Jason Spisak 25 Apr '00

25 Apr '00

Zopists, <dtml-in "_.range(0, 105, 5)"> <option value="<dtml-var "_.float(_['sequence-item'])/100">"> <dtml-var "_.float(_['sequence-item'])">% </option> </dtml-in> This code when viewed from a ZClass management interface in 2.1.6 crashes my Zope everytime. Any ideas? All my best, -- Jason Spisak 444(a)hiretechs.com

1 0

Zope Spun out
by Jason Spisak 25 Apr '00

25 Apr '00

I ran strace on each thread and all of them gave me back my command line except two. One of them doesn't give me back the prompt, it just hangs there with "about to attach 4bfb", the other doesn't give me pabk the prompt with: about to attach 4af3 wait4(19451, which is consequently the other process that hangs my prompt. Neither of these were the process that spiked. Any ideas where to go from here. It's still hung? -- Jason Spisak 444(a)hiretechs.com

1 0

Zope spun out
by Jason Spisak 25 Apr '00

25 Apr '00

BTW I run strace on that process and it gave me "about to attach 4c02" and that's it. When I ran the strace, the process stopped gobbling CPU. But Zope is still unresponsive. -- Jason Spisak 444(a)hiretechs.com

1 0

Zope spun out
by Jason Spisak 25 Apr '00

25 Apr '00

Okay, the thread is back in line, but Zope is still unresponsive. -- Jason Spisak 444(a)hiretechs.com

1 0

Zope just spun out
by Jason Spisak 25 Apr '00

25 Apr '00

I'm using 2.1.6 on RH 6.1 Right now Zope isn't responding after I did an undo in the management interface. The process is taking up 90% of the cpu power. I don't want to kill it, I want to get some useful info out of this. One more time...what can I do to get some info on this? hanging, -- Jason Spisak 444(a)hiretechs.com

1 0

ExtensionClass: calling basicnew from C code
by Andrew M. Kuchling 25 Apr '00

25 Apr '00

I'm still working with ExtensionClass to build a Versant module that supports persistence nicely, and just discovered the __basicnew__ method that returns an uninitialized instance of a class. Is there a good way to get the same effect as this method from the C level? Other than the following code: basicnew = PyObject_GetAttrString( classObj, "__basicnew__" ); if (basicnew == NULL) { Py_DECREF( classObj ); return NULL; } Erg = (VLinkObject*)PyEval_CallObjectWithKeywords(basicnew,NULL,NULL); This code seems to work fine; having to do a getattr seems inelegant, that's all. -- A.M. Kuchling http://starship.python.net/crew/amk/ I was never so amazed in my life as when the Sniffer drew his concealed weapon from its case and struck me to the ground, stone dead. -- Robertson Davies, first line of _Murther and Walking Spirits_

2 1

access control problem -- wrong URL
by David Brown 24 Apr '00

24 Apr '00

I gave the wrong URL to download my source ... it's really: http://members.home.net/davidbro/ZopeFish-0.0.4-bug.tgz sorry... thanks in advance. dave

1 0

Reference files in a product folder
by Morten W. Petersen 24 Apr '00

24 Apr '00

How do I do that? =] Example: Product LotsOfImages has 50 images within it's main ZClass, main; How do you get the URL of the images from within a DTML Document, in main? -Morten

2 6

access control problem.
by David Brown 24 Apr '00

24 Apr '00

I've been learning about Zope as I go along hacking on my ZopeFIsh project. For the most part things have gone well, most problems having solutions. But I seem to have wandered into a weird little problem. Here's how it goes... I instantiate my ZopeFish object. I go it in the management interface, and add a user. In another browser window (one that I never used to log into Zope), I go to the ZopeFish instance and log in using ZopeFish's user login facility. I go to the discussion group page, click the "new message (in browser)" link, write something, hit the update button. At this point ZoepFish will create a new message, set the subject and contents, and then redirect the browser to the message that has just been created. At this point Zope wants a username and password. If I cancel the prompt, it will now tell me that I am unauthorized to access the attribute "body". "Body" is the actual message. You see, I'm using a tenplate structure -- only the root object has an "index_html" member, and it points to a template that includes a "<dtml-var body>" directive. So I just implement the "body" member in any publishable objects, and they all use the template. So somehow, creating the new message didn't properly propagate the security settings, or something else that I don't understand. So how do I properly set up the access to the new item? I noticed that if I just stop and restart the Zope server that I no longer have problems seeing the message. So something's getting fixed on the reload. I've uploaded my current source to: ftp://members.home.net/davidbro/ZopeFish-0.4.0-bug.tgz if anyone wants to dig around and try to reproduce (and maybe even fix) the problem. I'm trying to RTFM, but finding the right FM is tough. ZopeFish requires the latest XMLDocument. Thanks in advance... dave

2 1