[Zope-dev] Making a ZSQL.DA fully multi-threaded?

[Dieter Maurer]

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