[Zope] Database connectors

[Maciej Wisniowski]

> 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