[Zope-dev] Re: ZSQL Methods in Z Classes

2001-05-21 Thread Shai Berger
Hi Guys, Last week, I wrote: Hi Guys, I wanted to use ZSQL Methods in Z Classes to share code between different parts of a large project. The different parts need to use similar, but separate, database namespaces, but I still wanted to use the same methods. [...] I tried to bypass

[Zope-dev] ZSQL Methods in Z Classes

2001-05-16 Thread Shai Berger
Hi Guys, I wanted to use ZSQL Methods in Z Classes to share code between different parts of a large project. The different parts need to use similar, but separate, database namespaces, but I still wanted to use the same methods. Now, ZSQL Methods treat their Database connection ID, for some

[Zope] A little sqltest patch: op=ne multiple

2001-01-31 Thread Shai Berger
Hi guys, The following trivial patch lets dtml-sqltest make sense of multiple inequality tests, that is: Currently dtml-sqltest name op="ne" multiple has the funny behavior of rendering nameval when passed a single value, and name in (val1,val2) when a list is

[Zope] Zope gets stuck

2001-01-25 Thread Shai Berger
Hi guys, We've repeatedly encountered a weird situation where Zope gets stuck. Then, when we kill one of the Zope processes, it is released and answers requests. Has anybody encountered anything like this? I know this is a little short on information, but we are still trying to figure more

RE: [Zope] hasRole bug or feature in 2.2.?

2001-01-16 Thread Shai Berger
Dieter writes: If I can't safely assume any of the above, would I be better off using a session product to track a user after log in so I can determine their roles from an unprotected document? Any other ways? If the session product uses cookies, you will have a situation similar to

Re: [Zope] REPOST: dtml-with doesn't work

2001-01-14 Thread Shai Berger
Philip has already made it clear that this was not his problem, but still, Dieter Maurer wrote: Just a remark: SQL methods do *NOT* look at the DTML namespace *AT ALL*, just at REQUEST (or the expliciitly passed keyword arguments). Thus, "dtml-with", "dtml-let" and friends are

[Zope] DCOracle bug?

2001-01-14 Thread Shai Berger
Hi guys, As I have written before, we are using DCOracle 1.3.2 / Oracle 8.0.5 on a Linux/i386. We need some LONG RAW columns, and we hold them in a special table long_data, with two columns, long_id (int) and long_data (long raw). Other tables where long data is needed hold references to this

[Zope] Raw post data

2001-01-14 Thread Shai Berger
Hi guys, For several reasons, I would like to have direct access to raw posted data in my dtml-code (an analogue of QUERY_STRING). Can anyone please show me the light? Thanks, Shai. ___ Zope maillist - [EMAIL PROTECTED]

[Zope] Re: Leaking Oracle connections processes

2001-01-08 Thread Shai Berger
Dieter Maurer wrote: Shai Berger writes: ... excess Oracle processes and zombies ... I have checked our installation and can confirm that both problems have gone. We do not yet know what caused the excess Oracle processes. After an increase of Zope's ZODB cache and an upgrade

[Zope] Re: Leaking Oracle connections processes

2001-01-07 Thread Shai Berger
Shai Berger wrote: I have checked a little before the disaster, and it seems that not all those processes actually have connections; the problem may be unrelated to open connections, but just to processes. A little progress: We just had it happen again, and checked to see how many live

[Zope] Leaking Oracle connections processes

2001-01-03 Thread Shai Berger
Hi guys, We are trying to build a site with Zope and Oracle, and we see again and again a situation where Oracle connections and processes are being leaked: the more we work, the more there are, until we reach Oracle's limit for number of processes. At this point, the Connection objects close