从服务器上拷贝数据库下来,想要对表格USER进行数据插入,结果显示以下错误,其中ABC为schema:
insert into "ABC"."USER" ("INTRANET_ID", "USER_NAME", "ROLE_ID", "DEPEND_ID", "ONLINE_FLAG", "BAK_1", "BAK_2", "BAK_3", "BAK_4") values('hethuang@cn.ibm.com', 'Elsa', 1, 1, 'Y', '', NULL, NULL, NULL)
com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: The insert or update value of the FOREIGN KEY "ABC.USER.USER_FK1" is not equal to any value of the parent key of the parent table.. SQLCODE=-530, SQLSTATE=23503, DRIVER=4.13.111
Error saving data
Inserted 0 row(s)
Updated 0 row(s)
Deleted 0 row(s)
可以从这个异常信息看出SQLCODE=-530,于是进行下一步排查。
insert into "ABC"."USER" ("INTRANET_ID", "USER_NAME", "ROLE_ID", "DEPEND_ID", "ONLINE_FLAG", "BAK_1", "BAK_2", "BAK_3", "BAK_4") values('hethuang@cn.ibm.com', 'Elsa', 1, 1, 'Y', '', NULL, NULL, NULL)
com.ibm.db2.jcc.am.SqlIntegrityConstraintVi
Error saving data
Inserted 0 row(s)
Updated 0 row(s)
Deleted 0 row(s)
可以从这个异常信息看出SQLCODE=-530,于是进行下一步排查。