More than one row with the given identifier was found:

太过爱你忘了你带给我的痛 2022-04-16 02:16 598阅读 0赞

Hibernate报这个错一般是数据映射问题,检查下数据库,删除重复数据即可;

select * from AUDIT_CATALOG_LOB_REL t

20181115172344803.png

根据多个字段判断为重复数据没将其删除即可。

delete from AUDIT_CATALOG_LOB_REL a where (a.ITEMGUID,a.DTGUID) in (select ITEMGUID,DTGUID from AUDIT_CATALOG_LOB_REL group by ITEMGUID,DTGUID having count(*) > 1)
and rowid not in (select min(rowid) from AUDIT_CATALOG_LOB_REL group by ITEMGUID,DTGUID having count(*)>1)

发表评论

表情:
评论列表 (有 0 条评论,598人围观)

还没有评论,来说两句吧...

相关阅读