[Web-SIG] WSGI thread affinity/interleaving

[Paul Moore]

On 12/18/05, Ian Bicking <ianb at colorstudy.com> wrote:
> James Y Knight wrote:
> > Does anybody have practical experience with the safety of moving a
> > DBAPI cursor between threads?
>
> I haven't done that, but SQLite (2?) notably doesn't allow you to move a
> connection between threads.  I'm not actually sure what problems it
> causes if you do move them -- it may simply be an overzealous warning.
>
> CCing DB-SIG -- people there might know more details.

I can confirm that cx_Oracle does not like cursors being shared
between threads. I even recall crashes (but can't verify this - once I
checked and found I shouldn't be doing this, I stopped - the problem
was intermittent, as is the nature of thread bugs :-().

Paul.