I wanted to do it because for some reason, my oracle connector (DCOracle) keeps disconnecting By DCOracle you mean DCOracle2?
What do you mean by 'keeps disconnecting'. What kind of errors do you see. We're using DCO2 - but so far we had only few accidents that something was disconnected and it was never because of DCOracle2. Reasons was usually: 1. Oracle database was restarted or database killed some sessions 2. Firewall killed connections 3. Oracle database had timeout for connections. Do you have error traceback or something like that?
and so I thought maybe it would be possible to define a python method to periodically check on it and reconnect it if necessary. There already is a method that checks whether a connection is opened. AFAIR it is in DCOracle.py - isOpen() but it isn't so easy to use this when connection is broken - doesn't work as expected. I have modified version of DCOracle2 that, in general, is changed to reconnect after incidents like those in 1,2,3 above happen. But this is only kind of workaround of the real problem that causes connections to die.
I imagined it wouldn't be so easy, but anyways I think I may be capable of convincing ppl at work to buy a mxodbc license... mxODBC is good but AFAIR it doesn't have StoredProcedures support (only select some_funtion() from dual and such things).
If you can please tell us what errors do you have from DCOracle2 - exactly - then we'll be possibly able to help you. What Zope version do you use? Do you have Zope-DB list? I think this thread should be moved there. -- Maciej Wisniowski