why sqlitedatabase.insert return -1?

Question

i am writing my first application, and I am also trying to incorporate a database, why sqlitedatabase insert method return -1 ??? i'm confused...

private static final int DATABASE_VERSION = 1;
private static final String DATABASE_NAME = "MyDatabase";
private static final String TABLE_CONTACT = "contact";
private static final String id_col = "id";
private static final String name_col = "name";
private static final String ph_num_col = "phone_number";

public static final String CREATE__TABLE_contact=
        "CREATE TABLE " + TABLE_CONTACT + " (" +
                id_col + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                name_col + " TEXT, " +
                ph_num_col + " TEXT" + ")";
public SqliteDatabaseHelper(Context context) {
    super(context, DATABASE_NAME, null, DATABASE_VERSION);
}


@Override
public void onCreate(SQLiteDatabase sqLiteDatabase) {
    //sakhte table haye morede niaz....
    sqLiteDatabase.execSQL(CREATE__TABLE_contact);
}

..............................................................

public void addContact(Contact contact){
    SQLiteDatabase db = this.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put("name",contact.getName());
    values.put("phone_number",contact.getPhone_number());

    Long test = db.insert(TABLE_CONTACT, null, values);
    if(test==  -1) {
        Log.i("insert", ""+test);
    }
    db.close();

}

-1 means that an error occurred while inserting the new row in the database. You need to provide more details: such as the specific SQL error. Take a look at your logcat — GVillani82, Dec 31 '16 at 14:03
try using _id instead of just id as a column name, http://stackoverflow.com/questions/3192064/about-id-field-in-android-sqlite — Avinesh, Dec 31 '16 at 14:04

score 0 · Answer 1 · answered Dec 31 '16 at 17:08

Please make sure that you defined your content provider subclass in AndroidManifest.xml file. Please find the following sample code. (You have to change according to your application.)

<provider
    android:name="com.example.app.MyDataBase"
    android:authorities="com.example.app"
    android:exported="false">
</provider>

Please refer android developer page, link.

why sqlitedatabase.insert return -1?

1 Answers1