[Zope] Database connections

Oleg Broytmann phd@sun.med.ru
Tue, 23 Mar 1999 19:34:12 +0300 (MSK)


On Tue, 23 Mar 1999, Christopher Petrilli wrote:
> On Tue, Mar 23, 1999 at 07:07:42PM +0300, Oleg Broytmann wrote:
> > 
> > 1. I started Potsgres, then started Zope, then restarted Zope - Zope
> > reestablished connections. It's Ok.
> 
> Ok, so we don't have a problem here :-)

   Good news! :)))

> > 2. I started Potsgres, then started Zope, then restarted Postgres. Zope
> > does not reestablish connections: This site is currently experiencing
> > technical difficulties...
> 
> I agree that if a remote cause forces a database connection to close, it
> should attempt to re-open it... that should be optional of-course, but
> should be the default.

   Yes, I think Zope must reopen connection.

> > 3. I started Potsgres, then started Zope, then went to management screen
> > and explicitly close a connection. Zope does not reestablish connections.
> 
> Nope, you closed the connection, you have to open it.  This I agree is
> the appropriate way to behave.

   May be...

   Well, what about such situation:

4. I started Potsgres, then started Zope, then worked with my application
and Postgres failed (postgres fails sometimes). Postgres returned an error
and closed connection. Zope, I think, should reopen the connection back,
but will it?

> Chris
> -- 
> | Christopher Petrilli                      ``Television is bubble-gum for
> | petrilli@amber.org                          the mind.''-Frank Lloyd Wright

Oleg.
---- 
    Oleg Broytmann  National Research Surgery Centre  http://sun.med.ru/~phd/
           Programmers don't die, they just GOSUB without RETURN.