Room error - how to deal with?

Question

I use Android Room library. I have entity Products:

@Entity(tableName = "products", foreignKeys = @ForeignKey(
        entity = Category.class,
        parentColumns = "code",
        childColumns = "category_id"))
public class Product {

    @PrimaryKey(autoGenerate = true)
    private Long id;

    @ColumnInfo(name = "name")
    private String name;

    @ColumnInfo(name = "description")
    private String description;

    @ColumnInfo(name = "category_id")
    private String categoryId;

and second entity.

@Entity(tableName = "categories")
public class Category {

    @PrimaryKey
    @NonNull
    private String code;

    @ColumnInfo(name = "name")
    private String name;

    @Ignore
    private List<Product> products;

When I try insert list of products:

new AsyncTask<Void, Void, Void>() {
            @Override
            protected Void doInBackground(Void... voids) {
                MyApplication.get().getDB().productDao().insertAll(productList);
                return null;
            }
        }.execute();

I get error when try insert products to DB.

Caused by: android.database.sqlite.SQLiteConstraintException: foreign key constraint failed (code 19)

How can I fix it?

Dublicate of https://stackoverflow.com/questions/44633483/android-room-foreign-key-constraint-failed — kamal verma, Nov 23 '17 at 07:44
@kamal verma in which place is a duplicate? I do not want to use my String UUID or some other kind of crutch — ip696, Nov 23 '17 at 07:49
same error https://stackoverflow.com/questions/44633483/android-room-foreign-key-constraint-failed — kamal verma, Nov 23 '17 at 07:50
In this question, he used int instead of Integer. At me Long. The error is the same, but the code is different, and the problem is different. Read the question carefully — ip696, Nov 23 '17 at 07:58

score 1 · Answer 1 · answered Nov 23 '17 at 08:49

I think this might have to do with the @Ignore annotation in the Category class, where you define the one-to-many owning relationship to Product.

Try and see what happens when you remove the @Ignore annotation. If that does not work, you can also use the @Relation annotation to define a one-to-many relationship. (Source: this SO answer)

Room error - how to deal with?

1 Answers1