SQLite exception: Database is locked issue

by

After doing some effort I did it (My app was working on perfect till android 2.3 but got db lock error when I used to run it on HoneyComb tablet).
I did using Semaphores (using lock in critical sections).

Example 1

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();
        }
    }

}

Example 2

public class DB {
    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  = mContext.openOrCreateDatabase(DATABASE_NAME, Context.MODE_PRIVATE, null);
            db.delete(TABLE_NAME, null, null);
            db.close();
        }
    }

    public void insert(Context mContext){
        synchronized(Lock) {
            SQLiteDatabase db  = mContext.openOrCreateDatabase(DATABASE_NAME, Context.MODE_PRIVATE, null);
            db.insert(TABLE_NAME, ..., ...);
            db.close();
        }
    }


}

Hope this would help Anyone in future 🙂

More Related Contents:

  1. Android SQLite data display to ListView
  2. Android :: SQLIte Db don't insert the datas
  3. IN clause and placeholders
  4. How to grant MODIFY_PHONE_STATE permission for apps ran on Gingerbread
  5. How to add manifest permission to an application?
  6. Lock the Android device programmatically
  7. Android Database Transaction
  8. About “_id” field in Android SQLite
  9. Best place to close database connection
  10. Screen orientation lock
  11. Backup and restore SQLite database to sdcard
  12. Permission Denial: this requires android.permission.INTERACT_ACROSS_USERS_FULL
  13. How to split comma-separated value in SQLite?
  14. Cursor adapter and sqlite example [closed]
  15. How to retrieve data from sqlite database in android and display it in TextView
  16. Turning on screen programmatically
  17. Android: column ‘_id’ does not exist
  18. Android Save images to SQLite or SDCard or memory
  19. Android Sqlite selection args[] with int values
  20. Android Cursor with ORMLite to use in CursorAdapter
  21. Android XML: RuntimeException: Failed to resolve attribute at index 6
  22. Is it possible to apply primary key on the text fields in android database
  23. How to store sqlite database directly on sdcard
  24. sqlite example program in android [closed]
  25. Create SQLite database in android
  26. Saving ArrayLists in SQLite databases
  27. Android SQLite auto increment
  28. Android Device Monitor “data” folder is empty
  29. difference between rawquery and execSQL in android sqlite database
  30. Get SQLite database from Android app

Leave a Comment