Android java : Error on SQLiteDatabase db = this.getWritableDatabase();

Question

Am a beginner at android java.

Error on SQLiteDatabase db = this.getWritableDatabase(); line in

public boolean deleteItem(Todomodel todomodel){

    SQLiteDatabase db = this.getWritableDatabase(); //HERE
    ContentValues cv = new ContentValues();
    int numb = todomodel.getId();
    String whereClause = "id=?";
    String whereArgs[] = {String.valueOf(numb)};
    db.delete("CUSTOMER_TABLE", whereClause, whereArgs);
    db.close();

    return false;
}

ERROR :

E/AndroidRuntime: FATAL EXCEPTION: main
    Process: com.example.monday, PID: 9794
    java.lang.NullPointerException: Attempt to invoke virtual method 'java.io.File android.content.Context.getDatabasePath(java.lang.String)' on a null object reference
        at android.content.ContextWrapper.getDatabasePath(ContextWrapper.java:330)
        at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:292)
        at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:238)
        at com.example.monday.database.deleteItem(database.java:72)

I already had called the getWritabledatabase in the insert function. But when I try to write again. It doesn't work.

check your database context if you are passing it, check your read/write storage permissions, check whether you are initialize or opening your database before performing query! — M. Bilal Asif
– M. Bilal Asif, Commented Jun 3, 2021 at 11:18
@M.BilalAsif I have checked various site and it all looked the same code. What you mean by passing the context. I have passed a model to the function and I get the correct output on the other side. and first time calling the database class I have passed the this.mainactivity.. — hashil semin
– hashil semin, Commented Jun 3, 2021 at 12:20
okay have you check your database path this should be checked carefully! — M. Bilal Asif
– M. Bilal Asif, Commented Jun 3, 2021 at 12:21

laalto · Accepted Answer · 2021-06-03 11:02:40Z

1

You need to pass a valid Context to your SQLiteOpenHelper constructor.

answered Jun 3, 2021 at 11:02

laalto

153k68 gold badges293 silver badges306 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

hashil semin Over a year ago

I have passed this.Mainactiviy to while creating a object for the database class like I did for the insert function which works perfect.

laalto Over a year ago

The Context can still be invalid. Please post code around how you are contructing the db helper, and maybe also how you are calling that code.

hashil semin Over a year ago

yes it works! but to call the update list which holds the set adapter is now the task that is in which I can't pass the context to from the adapter

Collectives™ on Stack Overflow

Android java : Error on SQLiteDatabase db = this.getWritableDatabase();

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related