Android: Null Pointer Exception

Question

I keep on having a NUllPointerException on the line:

return mDb.insert(DATABASE_TABLE, null, initialValues);

I don't know why. Can anyone help me? This is the SQLite database of my app:

public MessagesDBAdapter open() throws SQLException {
            mDbHelper = new DatabaseHelper(mCtx);
            mDb = mDbHelper.getWritableDatabase();
            return this;
        }

    public void close() {
        mDbHelper.close();
    }

    public long createNote(String phoneNo, String message) {
        ContentValues initialValues = new ContentValues();
        initialValues.put(KEY_RECIPIENT, phoneNo);
        initialValues.put(KEY_MESSAGE, message);

        return mDb.insert(DATABASE_TABLE, null, initialValues);
    }

    public boolean deleteNote(long rowId) {

        return mDb.delete(DATABASE_TABLE, KEY_ROWID + "=" + rowId, null) > 0;
    }

What's null? At least some of the stack trace might be handy. — Dave Newton
– Dave Newton, Commented Dec 7, 2011 at 3:02

Corey Sunwold · Accepted Answer · 2011-12-07 03:04:53Z

0

It seems like mDb isn't getting set. Have you called open() before calling createNote? Otherwise try adding a call to open() in the createNote method like this:

public long createNote(String phoneNo, String message) {
    ContentValues initialValues = new ContentValues();
    initialValues.put(KEY_RECIPIENT, phoneNo);
    initialValues.put(KEY_MESSAGE, message);

    open();

    return mDb.insert(DATABASE_TABLE, null, initialValues);
}

answered Dec 7, 2011 at 3:04

Corey Sunwold

10.3k6 gold badges53 silver badges55 bronze badges

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

Collectives™ on Stack Overflow

Android: Null Pointer Exception

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related