On 2007/11/29, Leandro Sales <[EMAIL PROTECTED]> wrote: > I had a single thread application that access one sqlite database > via SQLObject. Recently I change it and now I need to have multiples > threads accessing this database. I'm experimenting my new approach and > in some cases I get an exception from SQLObject, like this: > "OperationalError: database is locked" > Is there any way to have multiple threads accessing SQLite database? > for instance, just one thread write to the database and the others > have just read-only access. If it is possible, this solve my problem.
I've encountered this problem with SQLite while not using SQLObject. As far as I can tell, the short answer to your question is no. The long answer is that SQLite claims to be thread-safe [1] but as far as I can tell their definition of thread-safe is "will not corrupt your database" and not "operations will always suceed". Reading from the database in multiple threads should work if you are careful and your version of SQLite is recent enough, but if you read the answer to question 5 from the FAQ [2], it appears that writing to the database from multiple threads or proccesses will not succeed. I believe it is attempting multiple simultaneous write operations which raised the "database is locked" error. Given that you have a single application I would guess it would be possible to manually acquire a Python threading lock and wait for the database to free up if you are sufficiently careful. [1] http://www.sqlite.org/faq.html#q6 [2] http://www.sqlite.org/faq.html#q5 Schiavo Simon ------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
