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

Question

this is the error code:

09-27 11:56:01.425: WARN/System.err(10324): android.database.sqlite.SQLiteConstraintException: error code 19: constraint failed
09-27 11:56:01.435: WARN/System.err(10324):     at android.database.sqlite.SQLiteStatement.native_execute(Native Method)
09-27 11:56:01.435: WARN/System.err(10324):     at android.database.sqlite.SQLiteStatement.execute(SQLiteStatement.java:61)
09-27 11:56:01.435: WARN/System.err(10324):     at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1809)
09-27 11:56:01.435: WARN/System.err(10324):     at de.enough.appmate.dbase.CMSResource.updateItem(CMSResource.java:1103)
09-27 11:56:01.435: WARN/System.err(10324):     at de.enough.appmate.dbase.CMSResourceUpdater.updateItems(CMSResourceUpdater.java:178)
09-27 11:56:01.435: WARN/System.err(10324):     at de.enough.appmate.dbase.CMSResourceUpdater.loadUpdates(CMSResourceUpdater.java:102)
09-27 11:56:01.435: WARN/System.err(10324):     at de.enough.appmate.dbase.CMSResourceUpdaterRunnable.run(CMSResourceUpdaterRunnable.java:32)
09-27 11:56:01.435: WARN/System.err(10324):     at java.lang.Thread.run(Thread.java:1019)

and this is the method that is used

this.db.execSQL("INSERT INTO itemGalleryItems (id, imageCaption, imageUrl,itemID,orderIndex,displayInGallery) VALUES (?,?,?,?,?,?); ",
                        bindArgs);

the binArgs looks like:

String[] bindArgs = {
        (String) imageItem.get("id"),
        (String) imageItem.get("imageCaption"),
        (String) imageItem.get("imageName"),
        (String) item.get("id"),
        (String) imageItem.get("orderIndex"),
        (String) imageItem.get("displayInGallery")};

hope someone can help

thanx newone

in someone field defined the constraint which will not full fill when you insert the value check the constraint. please display your table structure here with so we can see what constraint are failed — Pratik
– Pratik, Commented Sep 27, 2011 at 10:08
I had the same problem, but for me, [this][1] worked. [1]: stackoverflow.com/questions/8117685/… — GreenBee
– GreenBee, Commented May 9, 2013 at 16:58

akjoshi · Accepted Answer · 2012-07-10 06:44:26Z

8

I have fixed this error;

instead of

long sucess = db.insert(TABLE_NAME_CONTACT_EXTRA, null, row);

use this to insert data in database

long sucess = db.insertWithOnConflict(TABLE_NAME_CONTACT_EXTRA, null,
                row, SQLiteDatabase.CONFLICT_IGNORE);

edited Jul 10, 2012 at 6:44

akjoshi

15.8k13 gold badges107 silver badges122 bronze badges

answered Jul 10, 2012 at 5:47

Manoj Kumar

811 silver badge2 bronze badges

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

Comments

mihail · Accepted Answer · 2012-11-01 12:05:49Z

4

I think if you have autoincrement field, you shouldn't include it in the query... is the "id" autoincrement?

edited Nov 1, 2012 at 12:05

answered Sep 27, 2011 at 10:19

mihail

2,17319 silver badges31 bronze badges

4 Comments

mihail Over a year ago

well, try it, just remove the id from the arguments and the query

newone Over a year ago

look here: link

IgorGanapolsky Over a year ago

I don't have autoincrement, but I have "text not null" for my columns. Does that matter?

mihail Over a year ago

if you have text not null you must provide value for this field

nixan · Accepted Answer · 2011-09-27 10:30:32Z

3

Have a look at your insert statement. Does it have all the columns that are declared to be not null in table create statement? And try no to use "id" column, use "_id" instead.

answered Sep 27, 2011 at 10:30

nixan

5231 gold badge6 silver badges13 bronze badges

5 Comments

newone Over a year ago

when i change id to _id than I get this failure : android.database.sqlite.SQLiteException: table itemGalleryItems has no column named _id: , while compiling: INSERT INTO itemGalleryItems (_id, imageCaption, imageUrl,itemID,orderIndex,displayInGallery) VALUES (?,?,?,?,?,?);

nixan Over a year ago

Changing id to _id was a reccomendation. If you provided an id column name in your table's create statement than you'll have to use id in all other statements.

newone Over a year ago

look here: link

nixan Over a year ago

Show your create table statement.

Sufian Over a year ago

In my case I was not binding a value for primary key. By adding that, I got rid of the problem.

Collectives™ on Stack Overflow

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

3 Answers 3

Comments

4 Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related