When a database lacks foreign key constraints, it's normal for it to
accumulate data with referential integrity violations over time.
Alternatively, this situation is also sometimes encountered in legacy
foreign key schemes where some "magic value", instead of NULL,
indicates a missing reference.
NotFound
| Modifier and Type | Field and Description |
|---|---|
| public static final NotFoundAction | EXCEPTION
Raise an exception when a foreign key value has no corresponding primary key value in the referenced table. |
| public static final NotFoundAction | IGNORE
Treat a foreign key value with no corresponding primary key value in the referenced table as a null reference. |
| Access | Constructor and Description |
|---|---|
| private |
| Modifier and Type | Method and Description |
|---|---|
| public static NotFoundAction | |
| public static NotFoundAction[] |
| EXCEPTION | back to summary |
|---|---|
| public static final NotFoundAction EXCEPTION Raise an exception when a foreign key value has no corresponding primary key value in the referenced table. | |
| IGNORE | back to summary |
|---|---|
| public static final NotFoundAction IGNORE Treat a foreign key value with no corresponding primary key value in the referenced table as a null reference. | |
| NotFoundAction | back to summary |
|---|---|
| private NotFoundAction() | |
| valueOf | back to summary |
|---|---|
| public static NotFoundAction valueOf(String name) | |
| values | back to summary |
|---|---|
| public static NotFoundAction[] values() | |