On 2/10/2012 11:45 AM, Sreekumar TP wrote:
There is no recovery from this situation-
If you try to rollback, you get the following error -"cannot rollback
savepoint, SQL statments in progress" or if you dont use SAVEPOINT -
"cannot rollback, no transaction is active"
If you start the transaction with BEGIN IMMEDIATE in App1, the writer in
App2 gets the following error " database is locked"
Just reset the statement that keeps the transaction open.
If you have more than one write and you want to be able to roll back
reliably if any of them fails, you should start an explicit transaction.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
