[Zope-DB] Per-user connections

Bo M. Maryniuck b.maryniuk@forbis.lt
Fri, 6 Dec 2002 12:41:36 +0200


On Friday 06 December 2002 11:56, Yves Bastide wrote:
> Care to elaborate?
All connections are in ZODB. There is a smart spool which cares about=20
timeout's, etc. Cloned and modified ZSQLMethod, StoredProcedure; develope=
d=20
some addition tools. Since session cannot contain unpickleable objects, i=
t=20
contains only information which connect to use. ZSQLMethond or=20
StoredProcedure or something else just looks which connection to use. Aft=
er=20
user logout (or timeout or session timeout or admin enforces to logout us=
er=20
etc) disconnects, runs a trigger for concrete user to end and mark his=20
session finish and closes & removes the connection. The only bug is that =
Zope=20
still keeps Oracle session in C layer (Matt?) 10-15 min.

Does not work under ZEO yet, since I have no one and haven't hacked it ye=
t. :)

--=20
Regards, Bogdan

You have moved the mouse. NT must be restarted for the changes to take ef=
fect.