On 10 Feb 2012, at 4:45pm, 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"
Correct. The database really is locked, since the structure of your application tells SQLite that it is going to make a change soon. If you're not ready to make the change yet, don't lock the database yet. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users