Re: Pyro and sqlite3 problem

2007-12-02 Thread Sébastien Ramage
I'm trying to build a client/server app the server use a sqlite3 database to store differents things the client ask the server to get value or store new entries in the database. The problem is that Pyro create a new thread for each client at first time I create the connection to database at server

Re: Pyro and sqlite3 problem

2007-12-02 Thread Sébastien Ramage
> Off hand -- ensure that each remote access runs the entire sequence > of "connect, cursor, execute, fetch, cursor-close, connection-close" > rather than trying to, say, create a cursor in one access and then use > that cursor on a second access... > > Or maybe create one long-run

Pyro and sqlite3 problem

2007-12-01 Thread Sébastien Ramage
Hi ! I'm trying to build an client/server app based on Pyro and sqlite3. But I have a problem using sqlite3 on the server I got this error : sqlite3.ProgrammingError: ('SQLite objects created in a thread can only be used in that same thread.The object was created in thread id 240 and this is th