67,550
社区成员
发帖
与我相关
我的任务
分享求救：hibermate foreign key导致的Cannot add or update a child row问题
1. a表：id 主键，key，name
2.b表：key主键，add
b表*.hbm.xml的配置文件相关配置
<many-to-one name="akey" column="a_key" class="路径/a" not-null="true" lazy="false"/>
SchemaUpdate-alter table b add index FKB23B8F27CFEAA390 (key), add constraint FKB23B8F27CFEAA390 foreign key (key) references a (id)
NewPooledConnection-com.mchange.v2.c3p0.impl.NewPooledConnection@246c7a05 handling a throwable.
java.sql.SQLIntegrityConstraintViolationException: (conn=25394) Cannot add or update a child row: a foreign key constraint fails (`数据库`.`#sql-54b_6332`, CONSTRAINT `FKB23B8F27CFEAA390` FOREIGN KEY (`key`) REFERENCES `a` (`id`))
2.b表：key主键，add
b表*.hbm.xml的配置文件相关配置
<many-to-one name="akey" column="a_key" class="路径/a" not-null="true" lazy="false"/>
SchemaUpdate-alter table b add index FKB23B8F27CFEAA390 (key), add constraint FKB23B8F27CFEAA390 foreign key (key) references a (id)
NewPooledConnection-com.mchange.v2.c3p0.impl.NewPooledConnection@246c7a05 handling a throwable.
java.sql.SQLIntegrityConstraintViolationException: (conn=25394) Cannot add or update a child row: a foreign key constraint fails (`数据库`.`#sql-54b_6332`, CONSTRAINT `FKB23B8F27CFEAA390` FOREIGN KEY (`key`) REFERENCES `a` (`id`))
...全文
请发表友善的回复…
发表回复
lxpandsq 2019-06-26
- 打赏
- 举报
找了半天资料，好像有三个办法可以解决问题：
1.a表设置lazy="false"？
2.b设置property-ref，目前用这个测试中
3.b表设置unique="true"
不太懂这三个的区别
