22 Jul
2004
22 Jul
'04
7:10 p.m.
Chris Withers wrote at 2004-7-21 16:44 +0100:
Brad Clements wrote:
I have set the SAPDB timeout to 32400 seconds.
Unless you have an extremely heavily loaded Zope, that's too low, and may be causing you problems...
That is the maximum allowed value in dbmgui.
My point is that unless you implement a connection pool model independent of Zope's threading, you WILL run into problems if you have ANY kind of timeout where the DA isn't smnart enough to reconnect connections that have closed...
All DA's I saw up to now, do a reconnect. But this is *WRONG" -- as part of a transaction may have been lost. After "reconnecting", they should raise an exception derived from "ConflictError" and let the complete request retry. -- Dieter