[Zope] Database Connections

Dieter Maurer dieter at handshake.de
Thu Nov 25 14:26:39 EST 2004


Jason Leach wrote at 2004-11-24 10:07 -0800:
>With Psycopg I have noticed that if the DB server is restarted (or
>just the Database) that Psycopg does not re-connect very well to the
>DB.

We are using Postgres heavily and do not make this observation.
Zope ("ZPsycopgDA") reconnects flawlessly to Postgres.

However, in principle, it is wrong to reconnect automatically.
It would be safer to reconnect and then raise an exception
(derived from "ConflictError") to retry the complete request.


-- 
Dieter


More information about the Zope mailing list