[cx-oracle-users] How to deal with lost connection to Oracle ?

[<prz...@po...>]

Hello,

(I am python and cx_oracle beginner so please excuse me ...)

I am going to write small python application which will fetch some small
data from many Oracles _once_ a minute for 24h/365.
These Oracles are backuped offline (shutdown, snapshot, startup).
Each Oracle has its own backup time. What I need is to
properly handle lost connections , e.g.:
minute 1: fetch data
minute 2: fetch data
minute 3: fetch data
minute 4: lost connection [1] (how to detect it ?) - backup started
minute 5: try to connect - failed [2] (how to detect it ?) - ongoing backup process
minute 6: try to connect - failed ...
minute 7: try to connect - failed ...
minute 8: try to connect - failed ...
minute 9: try to connect - successful ...
minute10: fetch data

How can I detect [1] and [2] ?


Regards
Przemyslaw Bak (przemol)





























----------------------------------------------------------------------
Duzi chlopcy lubia wampiry i krew.
http://linkint.pl/f2718