All geek questions in one place

Android.database.sqlite.SQLiteConstraintException

android.database.sqlite.SQLiteConstraintException: error code 19: constraint failure

error in my application and do not know why.

This happens when I add a new inbox to my database.

here is the Create statement of my inbox table:

CREATE TABLE inbox (uid text, title text, sender text, timeRecieved text, PRIMARY KEY(uid));

implemented using these static final strings;

public static final String LABEL_INBOX_UID = "uid";
    public static final String LABEL_INBOX_TITLE = "title";
    public static final String LABEL_INBOX_SENDER = "sender";
    public static final String LABEL_INBOX_TIME_RECIEVED = "timeRecieved";

    public static final int COLUMN_INBOX_UID = 0;
    public static final int COLUMN_INBOX_TITLE  = 1;
    public static final int COLUMN_INBOX_SENDER= 2;
    public static final int COLUMN_INBOX_TIME_RECIEVED = 3;

    public static final String TABLE_NAME_INBOX = "inbox";
    public static final String TABLE_CREATE_INBOX = "CREATE TABLE "
        + TABLE_NAME_INBOX + " (" + LABEL_INBOX_UID + " text, "
        + LABEL_INBOX_TITLE + " text, " + LABEL_INBOX_SENDER
        + " text, " + LABEL_INBOX_TIME_RECIEVED + " text, "
     + "PRIMARY KEY(" + LABEL_INBOX_UID + ")" + ");";

And here is the method that gets the inbox element and puts it inside contentValues ​​()

@Override
    protected void insertItem(InboxListItem object, String table) {
        InboxListItem item = object;
        inboxItemValue = new ContentValues();

        inboxItemValue.put(LABEL_INBOX_UID, item.getUid()); 
        Log.d(TAG, "item.getUid() " + item.getUid());
        inboxItemValue.put(LABEL_INBOX_TIME_RECIEVED, item.getTimeRecieved());
        Log.d(TAG, "item.getTimeRecieved() " + item.getTimeRecieved());
        inboxItemValue.put(LABEL_INBOX_TITLE, item.getTitle());
        Log.d(TAG, "item.getTitle() " + item.getTitle());
        inboxItemValue.put(LABEL_INBOX_SENDER, item.getSender());
        Log.d(TAG, "item.getSender() " + item.getSender());


        Log.d(TAG, "TABLE_CREATE_EVENTS =" + TABLE_CREATE_EVENTS);
        Log.d(TAG, "TABLE_CREATE_INBOX =" + TABLE_CREATE_INBOX);
        Log.d(TAG, "TABLE_CREATE_CONTACTS =" + TABLE_CREATE_CONTACTS);
        database().insert(TABLE_NAME_INBOX, null, inboxItemValue);
        Log.d(TAG, "database().insert(TABLE_NAME_INBOX, null, inboxItemValue);");


    }

O and here is the complete exception message:

11-22 12: 24: 39.606: ERROR/ (773): sender = Mit UID = 663b074a-16c8-46fb-A420-e0ebf716e212 title= (11/19/2010) timeRecieved = 2010-11-19T06: 02: 36.000Z 11-22 12: 24: 39.606: ERROR/ (773): android.database.sqlite.SQLiteConstraintException: 19: 11-22 12: 24: 39.606: / (773):
android.database.sqlite.SQLiteStatement.native_execute (Native ) 11-22 12: 24: 39.606: / (773): android.database.sqlite.SQLiteStatement.execute(SQLiteStatement.java:55) 11-22 12: 24: 39.606: / (773): android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1549) 11-22 12: 24: 39.606: / (773): android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1410) 11-22 12: 24: 39.606: / (773): com.kc.database.InboxDbWrapper.insertItem(InboxDbWrapper.java:44) 11-22 12: 24: 39.606: / (773): com.kc.database.InboxDbWrapper.insertItem(InboxDbWrapper.java:1) 11-22 12: 24: 39.606: / (773): com.kc.database.DbWrapper.insertAllItemsToDb(DbWrapper.java:42) 11-22 12: 24: 39.606: / (773): com.kc.database.InboxDbWrapper.populateTable(InboxDbWrapper.java:54) 11-22 12: 24: 39.606: / (773): com.kc.main.screen.HomeMainScreenOne.loadDataToDb(HomeMainScreenOne.java:225) 11-22 12: 24: 39.606: / (773): com.kc.main.screen.AbstractMainScreen.onCreate(AbstractMainScreen.java:125) 11-22 12: 24: 39.606: / (773): com.kc.main.screen.HomeMainScreenOne.onCreate(HomeMainScreenOne.java:51) 11-22 12: 24: 39.606: / (773): android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047) 11-22 12: 24: 39.606: / (773): android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2627) 11-22 12: 24: 39.606: / (773): android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2679) 11-22 12: 24: 39.606: / (773): android.app.ActivityThread.access $2300 (ActivityThread.java:125) 11-22 12: 24: 39.606: / (773): android.app.ActivityThread $H.handleMessage(ActivityThread.java:2033) 11-22 12: 24: 39.606: / (773): android.os.Handler.dispatchMessage(Handler.java:99) 11-22 12: 24: 39.606: / (773): android.os.Looper.loop(Looper.java:123) 11-22 12: 24: 39.606: / (773): android.app.ActivityThread.main(ActivityThread.java:4627) 11-22 12: 24: 39.606: / (773): java.lang.reflect.Method.invokeNative(Native ) 11-22 12: 24: 39.606: / (773): java.lang.reflect.Method.invoke(Method.java:521) 11-22 12: 24: 39.606: / (773): com.android.internal.os.ZygoteInit $MethodAndArgsCaller.run(ZygoteInit.java:868) 11-22 12: 24: 39.606: / (773): com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626) 11-22 12: 24: 39.606: / (773): dalvik.system.NativeStart.main(Native )

:

: Somemore. List, . :

// Variables used to create the events table
    public static final String TABLE_NAME_CONTACTS = "contactsList";

    public static final String LABEL_CONTACTS_UID = "uid";
    public static final String LABEL_CONTACTS_FULLNAME = "fullname";

    public static final String TABLE_CREATE_CONTACTS = "CREATE TABLE "
            + TABLE_NAME_CONTACTS + " (" + LABEL_CONTACTS_UID + " text, "
            + LABEL_CONTACTS_FULLNAME + " text, " + "PRIMARY KEY("
            + LABEL_CONTACTS_UID + ")" + ");";


    public static final int COLUMN_CONTACTS_UID = 0;
public static final int COLUMN_CONTACTS_FULLNAME = 1;

CREATE TABLE contactsList (uid text, fullname text, PRIMARY KEY(uid));

:

public static final String LABEL_EVENTS_UID = "uid";
    public static final String LABEL_EVENTS_TITLE = "title";
    public static final String LABEL_EVENTS_LOCATION = "location";
    public static final String LABEL_EVENTS_DATE = "date";
    public static final String LABEL_EVENTS_TIME = "time";
    public static final String LABEL_EVENTS_TIMEZONE = "timezone";

    public static final int COLUMN_EVENTS_UID = 0;
    public static final int COLUMN_EVENTS_TITLE = 1;
    public static final int COLUMN_EVENTS_LOCATION = 2;
    public static final int COLUMN_EVENTS_DATE = 3;
    public static final int COLUMN_EVENTS_TIME = 4;
    public static final int COLUMN_EVENTS_TIMEZONE = 5;

    // Variables used to create the events table
    public static final String TABLE_NAME_EVENTS = "events";
    public static final String TABLE_CREATE_EVENTS = "CREATE TABLE "
            + TABLE_NAME_EVENTS + " (" + LABEL_EVENTS_UID + " text, "
            + LABEL_EVENTS_TITLE + " varchar(30), " + LABEL_EVENTS_LOCATION
            + " varchar(30), " + LABEL_EVENTS_DATE + " varchar(30), "
            + LABEL_EVENTS_TIME + " varchar(30), " + LABEL_EVENTS_TIMEZONE
            + " varchar(30), " + "PRIMARY KEY(" + LABEL_EVENTS_UID + ")" + ");";

CREATE TABLE events (uid text, title varchar(30), location varchar(30), date varchar(30), time varchar(30), timezone varchar(30), PRIMARY KEY(uid));
+3
4

, , , "UID".

+8

, . :

CREATE TABLE inbox (uid integer PRIMARY KEY AUTOINCREMENT, title text, sender text, timeRecieved text);
+3

@jonney , . db, , . . , - , . , . , . , . .

+1
source

Try the following:

return db.insertWithOnConflict(YOURTABLENAME, null, initialValues, SQLiteDatabase.CONFLICT_IGNORE);
0
source

Source: https://habr.com/ru/post/1776220/

More articles:


All Articles