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

Question

I created a table named resources but when I insert values in it, this exception is thrown:

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

Here is my create table statement:

public static final String DATABASE_CREATE = 
    "CREATE TABLE " + table_resources + "(ID INTEGER PRIMARY KEY, 
    KEY_TYPE text, KEY_ENCODING text, KEY_WIDTH text, KEY_HEIGHT text, 
    KEY_DATA text, KeyIId text)";

The following is my insert code:

JSONObject show = data.getJSONObject(i);
if (show.get("type").equals("resource_updates")) {
    JSONArray resources = show.getJSONArray("resources");
    try {
        System.out.println("length of resources is is " + resources.length());
        for (int resourceIndex = 0; resourceIndex < resources.length(); resourceIndex++) {
            type = resources.getJSONObject(resourceIndex).getString("type").toString();
            encoding = resources.getJSONObject(resourceIndex).getString("encoding").toString();
            data1 = resources.getJSONObject(resourceIndex).getString("data").toString();
            id = resources.getJSONObject(resourceIndex).getString("id").toString();
            try {
                width = resources.getJSONObject(resourceIndex).getString("width").toString();
            } catch (Exception e) {
                System.out.println(e);
                width = "null";
            }
            try {
                height = resources.getJSONObject(resourceIndex).getString("height").toString();
            } catch (Exception e) {
                e.printStackTrace();
                height = "null";
            }
            db.insert(type,encoding,width,height, data1,iid);
        }
    } catch (Exception e) {
        e.printStackTrace();
        System.out.println(e + "exception");
        System.out.println("exception in  the resources");
    }
}

Can anyone tell me where could be the problem?

When you expect others to debug your code, its best if you provide the entire stacktrace. — Arnab Chakraborty
– Arnab Chakraborty, Commented Nov 14, 2011 at 5:44
make sure,is your table properly created?i think,your create query is having problem too. you didn't give a white space after table name in your create query.also column names you are using to retrieve data from table are different than you are using those in create query. — Hiral Vadodaria
– Hiral Vadodaria, Commented Nov 14, 2011 at 5:56

skynet · Accepted Answer · 2012-09-04 13:06:19Z

33

Constraint failed usually indicates that you did something like pass a null value into a column that you declare as not null when you create your table.

edited Sep 4, 2012 at 13:06

answered Nov 14, 2011 at 5:33

skynet

9,9086 gold badges46 silver badges52 bronze badges

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

2 Comments

skynet Over a year ago

Could you post your insert method as well? I assume it's a helper method that calls the actual SQLiteDatabase.insert method with your data

mayank_droid Over a year ago

perfect solution for table without primary keys!!

Martin Zeitler · Accepted Answer · 2017-03-03 05:29:47Z

0

In order to get more information about SQLite errors, one can use ADB dumpsys:

adb shell dumpsys dbinfo -v

combined with grep:

adb shell dumpsys dbinfo -v | grep executeForLastInsertedRowId

or grep'ed twice:

adb shell dumpsys dbinfo -v | grep executeForChangedRowCount | grep failed

edited Mar 3, 2017 at 5:29

answered Jul 17, 2016 at 1:58

Martin Zeitler

79.6k20 gold badges169 silver badges243 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related