I nam using ADO.net wrapper version of the SQLite, using sqlLiteAdapter to fill and update my Database.
I have two processes with 2 threads in each of the process.
Process A with Thread A1 reading, Thread A2 writing.
Process B with Thread B1 reading and B2 writing.
Thread A2 and B2 are sychronized through mutex, while thread A1 and B1 are free to read without any sync.
From what i understand from SQLite FAQ, the above scenario should be safe.
However, during a update of the database through sqlLiteAdapter->Update, the DB throw a "Concurrency violation:..." exception.
Since the DB already has readerwriter locks and thus support any number of readers from the application, and only allow one writer at any one time, why the above result in concurrency violation error??