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 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
-~----------~----~----~----~------~----~------~--~---

Reply via email to