yes it appears that MySQLDB, among its many limitations, is also
completely not threadsafe. Running a barebones web test to a MySQL
produces the same error. its a little amazing SA has made it for over
a year and nobody has really had this problem before.
So, for non-threadsafe DBAPIs we use the SingletonThreadPool, like
this:
meta = BoundMetaData('mysql://scott:[EMAIL PROTECTED]/test',
poolclass=pool.SingletonThreadPool)
It appears that I will have to make SingletonThreadPool the defualt
pool for the mysql module the same way it is for sqlite ....although Im
going to check MySQLDB now to see if thread-safety has been worked into
newer versions.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
