Thanks, that's perfect. I knew it had to be in the API somewhere, but
I couldn't find it.
On Mar 18, 5:44 am, Michael Bayer <mike...@zzzcomputing.com> wrote:
> On Mar 17, 2010, at 9:45 PM, chris e wrote:
>
>
>
> > Because of the way that we have our Oracle database setup, I have to
> > do the following to force every connection to use exact cursor
> > sharing.
>
> > dbapi = engine.dialect.dbapi
> > orig_connect = dbapi.connect
> > def exact_connect(*args, **kwargs) :
> > conn_obj = orig_connect(*args, **kwargs)
> > cursor = conn_obj.cursor()
> > cursor.execute('alter session set cursor_sharing = exact');
> > cursor.close()
> > return conn_obj
> > dbapi.connect = exact_connect
>
> > Is there a better way to do this? Is there a way to call a function
> > with the new connection every time one is created by the engine?
>
> sure -
> usehttp://www.sqlalchemy.org/docs/reference/sqlalchemy/interfaces.html?h...
>
>
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "sqlalchemy" group.
> > To post to this group, send email to sqlalch...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > sqlalchemy+unsubscr...@googlegroups.com.
> > For more options, visit this group
> > athttp://groups.google.com/group/sqlalchemy?hl=en.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
