[Z3-sqlos] Removal of the sqlos connection cache

[Brian Sutherland]

Hi,

I have been seeing this problem on my production instances:
http://mail.zope.org/pipermail/zope3-dev/2005-December/017052.html

On my way to try to solve this, I noticed that if a connection "goes
away" or is closed, the sqlos connection cache will still keep
delivering that connection until a server restart.

On further investigation, it appeared that there were a total of three
thread safe caches between the connection and it being used. One in
sqlobject, one in sqlos and one in zope.app.rdb (since r30682).

This is obviously silly, so I tried to fix this on a branch:

http://codespeak.net/svn/z3/sqlos/branch/jinty-connection

but this code is quite fundamental and I would appreciate some people
looking over it or testing before I commit it to the trunk.

One thing I am worried about with this code is that it changes the
sqlobject cache from a per-thread cache to a global cache. I am not sure
if this is a good or bad thing...

-- 
Brian Sutherland

Metropolis - "it's the first movie with a robot. And she's a woman.
              And she's EVIL!!"