[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 on

[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

[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

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 a

[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 ta

[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] http://lists.zope.or

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 > sim

[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 ourse

[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 has the funny behavior of rendering name<>val when passed a single value, and name in (val1,val2) when a list is passed. With this fix, the latter case