tags:

views:

348

answers:

2
A: 

It seems that more than process is trying to modify the database. You can have only connection open at any given time. More background of the problem may help us provided you with a more concrete answer.

Bozhidar Batsov
can we work with multiple tables of database at same time with same connection object of database suppose i have inserted value in table 1 and at same time also inserted value in table 2 of data base with same object of data base connection.
rajkumari
or is database locked exception occurred due to obj Connection.commit() line
rajkumari
+1  A: 

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

Stijn