we should probably be wrapping the commit()/rollback() etc methods for DB exceptions as well, currently its just execute() and cursor() AFAIK.
On Apr 2, 2007, at 3:41 PM, Greg Copeland wrote: > > > > On Apr 2, 12:36 pm, Paul Johnston <[EMAIL PROTECTED]> wrote: >> Greg, >> >> If you can send the traceback you get when such an error occurs, that >> would be helpful for providing Oracle support for this condition. >> >> Paul >> > > I assume this means that the exception is not being caught and wrapped > by an SQLAlchemy.exceptions exception? As you can tell, the > envionment for this test is cygwin. I also run/test on RHEL Linux. > > Traceback (most recent call last): > File "<stdin>", line 1, in ? > File "build/bdist.cygwin-1.5.20-i686/egg/sqlalchemy/engine/base.py", > line 266, in execute > File "build/bdist.cygwin-1.5.20-i686/egg/sqlalchemy/engine/base.py", > line 276, in execute_text > File "build/bdist.cygwin-1.5.20-i686/egg/sqlalchemy/engine/base.py", > line 350, in _execute_raw > File "build/bdist.cygwin-1.5.20-i686/egg/sqlalchemy/engine/base.py", > line 365, in _execute > File "build/bdist.cygwin-1.5.20-i686/egg/sqlalchemy/engine/base.py", > line 254, in _autorollback > File "build/bdist.cygwin-1.5.20-i686/egg/sqlalchemy/engine/base.py", > line 239, in _rollback_impl > File "build/bdist.cygwin-1.5.20-i686/egg/sqlalchemy/engine/ > default.py", line 55, in do_rollback > cx_Oracle.DatabaseError: ORA-03114: not connected to ORACLE > > To get this, I started python and interactively created and engine. I > then grabbed a connection by using engine.connect(). Once I had my > connection, I then pulled my network cable and issued the execute on > my connection. > > Let me know if you want me to go about this from another direction. > > Greg > > >> Greg Copeland wrote: >>> I'm using sqlalcehmy 2.5 with cx_Oracle 4.2.1. What is the >>> proper way >>> to detect an sqlalchemy operation has lost its database >>> connection and >>> reconnection/retry? The manual doesn't seem to say much about the >>> topic. When connection loss occurs, does SA throw the native dbapi >>> exception? If not, what exception will user code see? >> >>> I found that various threads on automatic reconnection and I >>> assume SA >>> does not currently, reliably, support automatic database >>> reconnection? >> >>> Greg > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---