android SQLiteConstraintException: error code 19: constraint failed

Question

I got android SQLiteConstraintException: error code 19: constraint failed exception. I saw there are tons of question in this topic, I've read a bunch of them, but still cant figure out what I did wrong. Mere is my table schema.

    private static final String DATABASE_CREATE = "CREATE TABLE calls (call_ID 
    INTEGER        AUTO    INCREMENT PRIMARY KEY NOT NULL, caller_id TEXT NOT NULL, "+
    caller_name TEXT NOT NULL, called_id TEXT NOT NULL, called_name    TEXT NOT NULL," + 
    "start_time TEXT NOT NULL, end_time TEXT NOT NULL);";

I add one single row, and it throws the exception.

   public long addCall(String caller_id, String caller_name, String called_id,
   String called_name, String start, String end) {
      ContentValues initialValues = createContentValues(caller_id, caller_name,called_id,called_name, start,end);
    return database.insert(DATABASE_TABLE, null, initialValues);
}

I overrided the SQLHelpers onOpen method, to clear the table on every open, but it didnt help.

public void onOpen (SQLiteDatabase database){
    database.execSQL("DROP TABLE IF EXISTS calls");
    onCreate(database);
    Log.w(DBHelper.class.getName(),"DB onOpen");
}

UPDATE: The problem is not that, I try to pass null, cause I only add these strings, and I got the error.

    dbAdapter.addCall("test", "test","test", "test", "test", "test");

UPDATE 2: This is my createContentvalue method:

public static final String CALLER_ID = "caller_id";
public static final String CALLER_NAME = "caller_name";
public static final String CALLED_ID = "called_id";
public static final String CALLED_NAME = "called_name";
public static final String START = "start_time";
public static final String END = "end_time";
public static final String DATABASE_TABLE = "calls";

    private ContentValues createContentValues(String caller_id, String caller_name, String called_id, String called_name, String start, String end) {
    ContentValues values = new ContentValues();
    values.put(CALLER_ID, caller_id);
    values.put(CALLER_NAME, caller_name);
    values.put(CALLED_ID, called_id);
    values.put(CALLED_NAME, called_name);
    values.put(START, start);
    values.put(END, end);
    return values;
}

Is there more info in the exception itself? Maybe which constraint failed? — Knickedi
– Knickedi, Commented Sep 29, 2011 at 18:54
I updated again, ther is my createContentValues method, and this is what the exception says: "09-29 19:12:13.329: ERROR/SQLiteDatabase(904): Error inserting start_time=test caller_id=test end_time=test caller_name=test" — czadam
– czadam, Commented Sep 29, 2011 at 19:13

Knickedi · Accepted Answer · 2011-09-29 19:54:50Z

1

Checked for null values in your method arguments? ;-)

Edit based on update

Haa, I knew it: A null value. ;-)
You use CALLER_NAME twice... (btw CALLER_ID too)

Edit based on comments

Besides the null value, he was trying to set the primary key (accidentally). That could have been the main reason (besides the actual null value).

edited Sep 29, 2011 at 19:54

answered Sep 29, 2011 at 18:46

Knickedi

8,7873 gold badges46 silver badges45 bronze badges

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

5 Comments

czadam Over a year ago

yes, thats not the problem. I updated my post, I try to insert a dummy raw, and still get the error.

czadam Over a year ago

hmm, thats very emberassing, i corrected it, but it did not solved my problem. I still got the same error (thank you for noticing anyway)

Knickedi Over a year ago

That's so simple it must be null. Please check whether you set all needed table column fields and whether your constants contain the right values and not the same column twice. They have such similar names only one letter difference...

czadam Over a year ago

I will check, for typos. But I tried to remove the NOT NULL from the schema, so it should accept null values. but still get the same error

Knickedi Over a year ago

Are you trying to set the primary key yourself? Then don't. Check your constants for primary key column. This is my last suggestion. I can't think of anything else...

Collectives™ on Stack Overflow

android SQLiteConstraintException: error code 19: constraint failed

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related