> These are very interesting. However, with SQLRelay, I am still bound > to use SQLRelayDA for Zope, and as Charlie postulated that stale > database connections are in part due to Zope's DA framework, > I wonder how using SQLRelay would address the problem; if the > connection to the SQLRelay server is lost, Zope would similarly hang
itself up, wouldn't it?
With SQLRelay you have SQLRelay client (in this case Zope DA), that connects to SQLRelay listener that is connected to database. When the network connection to the database is broken then listener becomes disconnected, but when you have some queries from the client (Zope DA) then those reach SQLRelay listener and become hung (in wait state) till connection becomes operational again (im not sure but this may cause all zope threads to be busy and Zope won't be responding). There were some questions about this recently on sqlrelay-discussion. - Maciej Wisniowski _______________________________________________ Zope-DB mailing list [email protected] http://mail.zope.org/mailman/listinfo/zope-db
