Hello, 
I had a doubt of sqlite transactions across threads. 
I have a multithreaded application which shares the same sqlite
connection across threads. I had a few doubts
1) If I do a begin transaction and insert on one thread. Then do a
insert on the second thread and finally a commit on the first thread
will the insert from the second thread succeed or will it fail saying
SQLITE_BUSY? if it succeeds, will the insert on the second thread be a
part of the transaction on the first thread?
2) When I do a Begin transaction will I get a transactionId? 
3) If one thread is in the middle of a transaction and another thread
does a begin transaction, will it be able to start its own transaction
or will it fail with SQLITE_BUSY.?
 
Kindly let me know, 
 
Regards,
Shailesh.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to