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

Question

I've this code for creating my sqlLite DB in android application:

private static final String CREATE_TABELLA_PERSONE = "CREATE TABLE TB_PERSONE "
+ "(_ID integer,"
+ "CODICE_PERSONA text not null, DESC_PERSONA text null, "
+ "PRIMARY KEY (CODICE_PERSONA));";

and

private static final String CREATE_TABELLA_USCITE = "CREATE TABLE AN_USCITE "
+ "(_ID integer, "
+ "CODICE_USCITA text null, SCADENZA text null, DATA text null,"
+ "PERSONA text not null REFERENCES TB_PERSONE(CODICE_PERSONA) ON DELETE NO ACTION ON UPDATE      CASCADE,PRIMARY KEY(CODICE_USCITA));";

When i call the function for DELETE a row in "TB_PERSONE"

public int SQLdelete(String tabella, String id) {
    return database.delete(tabella, "_ID=" + id, null);
}

the application show me this error:

04-27 11:15:27.152: E/AndroidRuntime(22031): FATAL EXCEPTION: main
04-27 11:15:27.152: E/AndroidRuntime(22031): android.database.sqlite.SQLiteConstraintException:           
foreign key constraint failed (code 19)
04-27 11:15:27.152: E/AndroidRuntime(22031):    at android.database.sqlite.SQLiteConnection.nativeExecuteForChangedRowCount(Native Method)
04-27 11:15:27.152: E/AndroidRuntime(22031):    at android.database.sqlite.SQLiteConnection.executeForChangedRowCount(SQLiteConnection.java:727)
04-27 11:15:27.152: E/AndroidRuntime(22031):    at android.database.sqlite.SQLiteSession.executeForChangedRowCount(SQLiteSession.java:754)
04-27 11:15:27.152: E/AndroidRuntime(22031):    at android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:64)
04-27 11:15:27.152: E/AndroidRuntime(22031):    at android.database.sqlite.SQLiteDatabase.delete(SQLiteDatabase.java:1494)
04-27 11:15:27.152: E/AndroidRuntime(22031):    at it.jackpot21.personalmoney.DbAdapter.SQLdelete(DbAdapter.java:89)
04-27 11:15:27.152: E/AndroidRuntime(22031):    at it.jackpot21.personalmoney.PersoneActivity$5.onClick(PersoneActivity.java:215)
04-27 11:15:27.152: E/AndroidRuntime(22031):    at android.view.View.performClick(View.java:4084)
04-27 11:15:27.152: E/AndroidRuntime(22031):    at android.view.View$PerformClick.run(View.java:16966)
04-27 11:15:27.152: E/AndroidRuntime(22031):    at android.os.Handler.handleCallback(Handler.java:615)
04-27 11:15:27.152: E/AndroidRuntime(22031):    at android.os.Handler.dispatchMessage(Handler.java:92)
04-27 11:15:27.152: E/AndroidRuntime(22031):    at android.os.Looper.loop(Looper.java:137)
04-27 11:15:27.152: E/AndroidRuntime(22031):    at android.app.ActivityThread.main(ActivityThread.java:4745)
04-27 11:15:27.152: E/AndroidRuntime(22031):    at java.lang.reflect.Method.invokeNative(Native Method)
04-27 11:15:27.152: E/AndroidRuntime(22031):    at java.lang.reflect.Method.invoke(Method.java:511)
04-27 11:15:27.152: E/AndroidRuntime(22031):    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:786)
04-27 11:15:27.152: E/AndroidRuntime(22031):    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:553)
04-27 11:15:27.152: E/AndroidRuntime(22031):    at dalvik.system.NativeStart.main(Native Method)

Can someone help me pls?
Thanks a lot! :)

EDIT:
I solved it by putting ON DELETE SET NULL.
Thanks at all!

what you have tried? check this link: stackoverflow.com/questions/8117685/… — Maulik
– Maulik, Commented Apr 27, 2013 at 11:55
and also check this one: stackoverflow.com/questions/14929277/… — Maulik
– Maulik, Commented Apr 27, 2013 at 12:01

petrch · Accepted Answer · 2013-04-27 12:06:25Z

2

It seems you are deleting a record from TB_PERSONE, which is referenced by record(s) from table AN_USCITE.

So,

1) either delete the records from AN_USCITE prior to deleting record from TB_PERSONE.

or

2) set ON DELETE CASCADE in your foreign key definition:

...
PERSONA text not null REFERENCES TB_PERSONE(CODICE_PERSONA) ON DELETE CASCADE ...
...

answered Apr 27, 2013 at 12:06

petrch

5323 silver badges6 bronze badges

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

2 Comments

Hikari Over a year ago

but I must not delete the record in AN_USCITE if I delete one in TB_PERSONE.

Kitesurfer Over a year ago

if you still need the AN_USCITE you may need some mapping table

CL. · Accepted Answer · 2013-04-27 12:02:53Z

0

This means that the AN_USCITE table still contains some record that references the person you're trying to delete.

answered Apr 27, 2013 at 12:02

CL.

182k18 gold badges241 silver badges282 bronze badges

Comments

nang_kring · Accepted Answer · 2014-07-01 07:20:55Z

0

Please make sure that String id not null so your code below can be executed.

public int SQLdelete(String tabella, String id) {
    return database.delete(tabella, "_ID=" + id, null);
}

answered Jul 1, 2014 at 7:20

nang_kring

711 silver badge2 bronze badges

Collectives™ on Stack Overflow

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

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related