[Zope-DB] Re: Zope database connectivity

[Pawel Lewicki]

Hi,

Maciej Wisniowski napisał(a):
> 
>> If one is careful, one can find a reliable solution...
>>
> Hopefully I think I did this today...
> 
> I've found that psycopg pool implementation has nice
> class:
> 
> class PersistentConnectionPool(AbstractConnectionPool):
>    """A pool that assigns persistent connections to different threads.
> 
>    Note that this connection pool generates by itself the required keys
>    using the current thread id.  This means that untill a thread put away
>    a connection it will always get the same connection object by successive
>    .getconn() calls. This also means that a thread can't use more than one
>    single connection from the pool.
>    """
> 
> I used this, and finally I have DCOracle2 with connection pool, without
> volatile attributes (I didn't changed implementation of stored 
> procedures yet),
> with ability to reconnect after things like DB restart and with REAL 
> ability to
> open/close connections from ZMI.

Did anyone try SQL Relay as a bridge? They say "When using SQL Relay, 
the database can be bounced without having to restart Zope"


Pawel Lewicki