org.hibernate.exception.ConstraintViolationException

最新推荐文章于 2021-04-29 18:37:16 发布

转载最新推荐文章于 2021-04-29 18:37:16 发布 · 203 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/weipeng/archive/2012/07/12/2587459.html

文章标签：

#java

本文探讨了在使用Hibernate进行数据库操作时遇到的'org.hibernate.exception.ConstraintViolationException'错误，通常由于字段设置为唯一值而无法插入重复记录。通过实例分析，解释了如何识别和解决此类问题。

org.hibernate.exception.ConstraintViolationException

今天遇到这个错误，网上查了下，大多说是有必填字段没有填，搞了很久没搞定，最后发现不是因为这个问题，而是因为字段设置了唯一值，如果表中已存在此记录，再插入则报此错误。

Hibernate: insert into membership.t_user (login_id, password, type, status, email, mobile, first_name, last_name, nickname, gender, birthday, country, region, creation_date, last_update_date, join_confirm_date, activation_date, deactivation_date, register_code, join_expire_date) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
org.springframework.dao.DataIntegrityViolationException: could not insert: [com.igen6.sac.ms.bean.TUser]; SQL [insert into membership.t_user (login_id, password, type, status, email, mobile, first_name, last_name, nickname, gender, birthday, country, region, creation_date, last_update_date, join_confirm_date, activation_date, deactivation_date, register_code, join_expire_date) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [com.igen6.sac.ms.bean.TUser]

转载于:https://www.cnblogs.com/weipeng/archive/2012/07/12/2587459.html