[sqlalchemy] Re: SQLite connections shared across threads (test case and logs)

2008-11-16 Thread Michael Bayer
On Nov 15, 2008, at 10:33 PM, Randy Syring wrote: Thank you so much for your response, I am extremely grateful. However, I am still getting exceptions thrown from SQLite for sharing connections across threads. Unfortuantely I cant reproduce your error now, whereas it was quite frequent

[sqlalchemy] Re: SQLite connections shared across threads (test case and logs)

2008-11-16 Thread Michael Bayer
here is an interesting thread related to this subject: http://www.modpython.org/pipermail/mod_python/2006-August/021854.html this person reported problems with threading.local() in conjunction with mod_python. Its unfortunate that I can't locate any Python bug reports or anything to

[sqlalchemy] Re: SQLite connections shared across threads (test case and logs)

2008-11-16 Thread Michael Bayer
On Nov 15, 2008, at 4:53 PM, Randy Syring wrote: When I run the exact same code using PyISAPIe, I get the following log file, which shows many exceptions all propagating up to my application and hosing it: Reading Graham's comments on threading:

[sqlalchemy] Re: SQLite connections shared across threads (test case and logs)

2008-11-16 Thread Randy Syring
On Nov 16, 11:30 am, Michael Bayer [EMAIL PROTECTED] wrote: I've looked into PyISAPIe.    Suffice to say this seems to be an   extremely new project.  Their homepage is blank: It has been around for a couple years: http://web.archive.org/web/*/http://pyisapie.sourceforge.net/ But I agree

[sqlalchemy] Re: SQLite connections shared across threads (test case and logs)

2008-11-15 Thread Michael Bayer
On Nov 15, 2008, at 4:53 PM, Randy Syring wrote: I went ahead and produced what I hope is a very narrow test case to show that I am not explicitly holding onto connections (unless I completely misunderstand, which is possible). Here is my test code: http://paste.pocoo.org/show/91285/

[sqlalchemy] Re: SQLite connections shared across threads (test case and logs)

2008-11-15 Thread Randy Syring
On Nov 15, 6:39 pm, Michael Bayer [EMAIL PROTECTED] wrote: Thank you so much for your response, I am extremely grateful. However, I am still getting exceptions thrown from SQLite for sharing connections across threads. The explicit connection as well as the threadlocal strategy are all