[Zope-DB] Re: Auto-reconnect in DCOracle2

[Matthew T. Kromer]

Chris Withers wrote:

> Matthew T. Kromer wrote:
>
>> The DA is only going to know that the connection closed if it gets an 
>> error sending a command :(
>
>
> Yeah, kinda figured that :-(
>
>> The DA's query method has a lot of try/except wrappers to try to 
>> boost it around the connection dissapearing and then causing a 
>> reconnect to take place.
>
>
> Not sure I quite understand you there. Where's the code so I can take 
> a peak?
> It sounds like you're saying there's already code there to do what I 
> want;
> ie: if a query would fail because the connection is gone, then try and 
> connect again before the query. is that the case?


You want the query method of db.py in ZOracleDA.


>
> cheers,
>
> Chris
>


-- 
Matt Kromer
Zope Corporation  http://www.zope.com/