Hi Michael,
Thanks for the answers.
> also, when you say you "triggered" the problem, can you do that
> predictably ? can you send a small test program that does it every
> time ? otherwise it sounds like a threading thing (if thats at all
> possible).
>
Very much so. Everytime I run my budding application I trigger the problem.
>is there any chance the Connection youre using is being shared
>between threads ? thats also not supported.
Hmm Interresting question.... As you can see from the code snippet I sent
previously, I am using PyQt. Hence that is multithreaded. I hadn't thought
about it, but since the data processing is being run by some dynamically
created widget, it is essentially run in a different thread.
I moved the "connect" to the method handling the data and the problem
disappeared.
It would be easy enough to make sure all the "flushes" are done in a single
thread of execution, but can you share a session across multiple thread if
you ensure that anything dealing with connection (most methods of the session
save maybe for "save") are executed by a single thread? IOW if you modify an
object belonging to a session in a different thread, will the session notice?
Regards,
François
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/sqlalchemy
-~----------~----~----~----~------~----~------~--~---