We are using sqlite056.jar in our code. While inserting into database in batch we are getting exception on line when we going to commit.
Lines of Code
<object of Connection>.commit();
<object of Connection>.setAutoCommit(true);
Exception
java.sql.SQLException: database locked
Connection needs to be closed after each query. If any of the connections still persist. I had got the same error on Java desktop apps, now solved.
Reading an SQLite database sets the locking state to Shared. Multiple readers can be active at the same time.
Writing to an SQLite database sets the locking state to Exclusive. No other processes can be active at that time.
You can find a detailed explanation on http://www.sqlite.org/lockingv3.html
It seems that more than one process is trying to modify the database. You can have only one connection open at any given time. More background on the problem may help us provide you with a more concrete answer.
In my case, I forgot to add WHERE clause in my UPDATE query, and that gives "database locked" error.
Carefully check your queries.
Edit: I forgot to indicate that I have used a type of UPDATE query where I'm changing multiple attributes:
UPDATE Users SET weight = 160, desiredWeight = 145 WHERE id = 1;
SQL statement in question looked like - and so suggesting that the query was UPDATE with missing WHERE comes across as guess-work. What would have been more appropriate in this case was to ask (in a comment) what the SQL query looked like - hinting that the cause might be something similar to a missing WHERE clause.
Close DB Browser (worked for me) or anything else accesses the database
