[Zope] Database connections

Christopher Petrilli petrilli@amber.org
Tue, 23 Mar 1999 11:40:04 -0500


On Tue, Mar 23, 1999 at 07:34:12PM +0300, Oleg Broytmann wrote:
> > 
> > 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.

Well, actually it should be the job of the DA, not Zope.  It's not
spelled out in a standard anywhere, which probably should be solved.
More documentation probably :/  But hey, someone's gotta know what the
DA is really supposed to do, other than looking at an existing one.

>    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?

Don't honestly know if it WILL, but it seems reasonable that it should
be capable of trying at the very least.  Again, this is the
responsibility fo the DA, not Zope... that should be made clear.  You're
using a 3rd party DA, so you might want to talk to them about it as
well.

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