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
-~----------~----~----~----~------~----~------~--~---
