Re: [sqlite] Concurrent access to database

2012-01-23 Thread Marcello Botrugno
Il 23/01/2012 16:27, Simon Slavin ha scritto: On 23 Jan 2012, at 1:56pm, Marcello Botrugno wrote: When I have four or more threads accessing to the database I see the error message: "database table is locked". This happens when a thread begins a new Transaction, probably becau

[sqlite] Concurrent access to database

2012-01-23 Thread Marcello Botrugno
Hi All, I have an application which starts two or more threads. Each thread open a separate connection to the database and in each transaction, modifies various tables of it. I use third-party library to access the SQLite database which make it possible to have an uniform access to different

[sqlite] Windows Thread-safe

2012-01-20 Thread Marcello Botrugno
Hi all, I am new of SQLite and I am developing a multithread application using SQLite 3.7.9 on MS Windows. I am using the precompiled version of SQLite downloaded from www.sqlite.org. Each thread of the application, opens a private connection to the database. Im observing that, if for example