Re: Accessing a database from a multithreaded application

2005-11-23 Thread Christoph Zwerschke
Alan Kemp schrieb: > I have a problem that is half python, half design. I have a > multithreaded network server working, each client request spawns a new > thread which deals with that client for as long as it is connected > (think ftp style rather than http style connections here). Each thread >

Re: Accessing a database from a multithreaded application

2005-11-23 Thread Frithiof Andreas Jensen
"Alan Kemp" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > Can someone suggest a better (ie, valid) strategy for this? Pass the connection to the thread as a parameter and use it to create a cursor local to the thread. You may have to create a connection per thread also - in

Accessing a database from a multithreaded application

2005-11-22 Thread Alan Kemp
Hi, I have a problem that is half python, half design. I have a multithreaded network server working, each client request spawns a new thread which deals with that client for as long as it is connected (think ftp style rather than http style connections here). Each thread gets passed a reference