Under certain circumstances the Python connection object will try to reconnect automatically.  This raises questions about the state machine for this process:
 
1) once you instance a connection object, is it usable for the lifetime of your python process or are there circumstances where you must instance a new one to reconnect to the database?
 
2) if the connection object is usable for the lifetime of your python process, are there (or could there be) ways to monitor and control its state?  E.g. force it to try to reconnect right away, configure its retry timer, inquire or ping as to its state, etc...
 
3) if the connection object is not usable for the lifetime of your python process, what error codes indicate this definitively?
 
Thanks,
 
Jeff Robbins

Reply via email to