Error while inserting data into SQLiteDatabase in Android

Question

I initial object db and called its method from my current class:

        db = new DBHelper(context);
        db.addCallerInfo(FragmentCaller.iName.getText().toString(),
                FragmentCaller.sex.getSelectedItemPosition(),
                FragmentCaller.iAddress.getText().toString(),
                FragmentCaller.iTel.getText().toString(),
                FragmentCaller.callerType.getSelectedItemPosition(),
                FragmentCaller.iSpecify.getText().toString());

In DBhelper class:

public void addCallerInfo(String name,int   sex ,String address,String  tel,int  callerType_id,String  specify) {
        ContentValues values = new ContentValues();
        values.put("name", name);
        values.put("sex", sex);
        values.put("address", address);
        values.put("tel", tel);
        values.put("specify", specify);
        values.put("callerType_id", callerType_id);
        db.insert(TableHelper.TABLE_callerInfo, null, values);
    }

Then it has problem java.lang.NullPointerException:

Attempt to invoke virtual method long android.database.sqlite.SQLiteDatabase.insert(java.lang.String, java.lang.String, android.content.ContentValues) on a null object reference

Help please! Thanks.

I think it is init? public void onCreate(SQLiteDatabase db) { this.db = db; } — Lay Leangsros, Aug 11 '15 at 04:29
onCreate method only called when your database create for first time. so when your restart the app, value of db will be null. — Dhaval Patel, Aug 11 '15 at 04:35

score 2 · Answer 1 · edited Aug 11 '15 at 05:03

2

Add below line in addCallerInfo() method. Then you can insert contentValues into Data Base.

   SQLiteDatabase db = this.getWritableDatabase();

edited Aug 11 '15 at 05:03

N J

27,217
13
76
96

answered Aug 11 '15 at 04:48

Saritha G

2,588
1
15
27

Thanks. I added this line it worked – Lay Leangsros Aug 11 '15 at 05:51
Glad to help u. Can you accept this as answer. – Saritha G Aug 11 '15 at 06:01

HassanUsman · Answer 2 · 2015-08-11T06:56:43.213

-1

You can't declare the Database type Writable or Readable

First declare it then inserting values like this:

 SQLiteDatabase database = this.getWritableDatabase();

And For just Readable database

 SQLiteDatabase db = this.getReadableDatabase();

edited Aug 11 '15 at 06:56

answered Aug 11 '15 at 04:55

HassanUsman

1,787
1
20
38

Error while inserting data into SQLiteDatabase in Android

2 Answers2