DB Locking issues

[jarofgreen]

Have seen this error:

at android.database.sqlite.SQLiteDatabase.dbopen(Native Method)
11at android.database.sqlite.SQLiteDatabase.(SQLiteDatabase.java:2005)
12at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:905)
13at android.database.sqlite.SQLiteOpenHelper.getReadableDatabase(SQLiteOpenHelper.java:197)
14at uk.co.jarofgreen.cityoutdoors.Storage.getFeatures(Storage.java:148)
15at uk.co.jarofgreen.cityoutdoors.UI.BrowseMapActivity$MarkerTask.doInBackground(BrowseMapActivity.java:240)
16at uk.co.jarofgreen.cityoutdoors.UI.BrowseMapActivity$MarkerTask.doInBackground(BrowseMapActivity.java:1)

Reading up, there are several steps to look into:

try {} finally {} on all db helper calls to make sure close is called in case of exception.

Singleton Helper, only one?

Is a Synchronized Lock something to look into?

http://stackoverflow.com/questions/7657223/sqlite-exception-database-is-locked-issue

public class DbExp extends SQLiteOpenHelper{
    public static String Lock = "dblock";
    private static final String DATABASE_NAME = "db.db";
    private static final String TABLE_NAME = "table_name";

    public void delete(Context mContext){
        synchronized(Lock) {
            SQLiteDatabase db  = getWritableDatabase();
            db.delete(TABLE_NAME, null, null);
            db.close();
        }
    }

    public void insert(){
        synchronized(Lock) {
            SQLiteDatabase db  = getWritableDatabase();
            db.insert(TABLE_NAME, ..., ...);
            db.close();
        }
    }

}```