[Zope-DB] diconnecting

D. Rick Anderson ruger@comnett.net
Thu, 27 Dec 2001 10:33:03 -0800 (PST)

I'm having a problem with our database connections dropping when a database 
server is rebooted or the network is interupted. What sucks is that it 
still shows as being connected in Zope. The only way I know that it isn't 
is either by trying something on the web site that uses the database server 
or by doing a test on the connection. I can get the connection back by 
closing the connection and then opening it again, but that's only if I'm 
aware that it's down. Is there some way to prevent this? Can Zope 
automatically re-open a connection somehow? 5 out of our 7 database servers 
are on the other end of a 62 mile T1 and if it goes down, I need Zope to 
bring the connection back up when the line comes back up. Can this be done?