Hi All,
we are working on a multi-threaded
application in linux 2.4.20 using sqlite(2.8.13)
database. we use single database handle for all the
threads to access the database and the handle is
protected with mutex. The handle is kept open for the
lifetime of the application.
we have kept provision to update the database from
multiple threads serially.
The issue is, if we do a "begin transaction" in one
thread and "commit transaction" in another thread ,
then
we get the error "database is locked". But if try to
update the database from multiple thread serially even
if a transaction is not committed it is successful.
Can anyone tell us is it the expected behaviour ?
Success case :
thread1 : begin transaction
thread1 : update database.
thread2 : update database.
thread1 : commit transaction.
Failure case:
thread1: begin transaction.
thread1: update database.
thread2: commit transaction( failure).
thread2: update (failure).
Thanking in advance,
Roushan
___________________________________________________________
Yahoo! Photos NEW, now offering a quality print service from just 7p a photo
http://uk.photos.yahoo.com
