Error Database Not Open

Hey I'm trying to insert data in the SQLite database, but everytime I try to insert the logcat shows the error. THe error ir shown on a service that gets the calllog data and inser

Solution 1:

Don't you want this code

 if (!db.isOpen()) {
        getApplicationContext().openOrCreateDatabase(
                "/data/data/com.my_app/databases/mydb.db",
                SQLiteDatabase.OPEN_READWRITE, null);
 }

to be:

if (!db.isOpen()) {
    db = getApplicationContext().openOrCreateDatabase(
                "/data/data/com.my_app/databases/mydb.db",
                SQLiteDatabase.OPEN_READWRITE, null);
 }

?

Also, in the function

publicTheContentObserver(Handler h) {
        super(h);
        OpenHelperhelper=newOpenHelper(getApplicationContext());
        SQLiteDatabasedb= helper.getWritableDatabase();
    }

helper and db are local variables, not class members. This means that the database that you open here is not used for anything, anywhere.