[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?
Thanks,
Rick