org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

最新推荐文章于 2025-02-25 14:05:45 发布

原创最新推荐文章于 2025-02-25 14:05:45 发布 · 1.1k 阅读

本内容遵循CC 4.0 BY-SA版权协议

本文介绍了一种在使用Hibernate框架时遇到的唯一约束异常问题及其解决方案。问题源于级联添加数据过程中违反了数据库的唯一性约束，通过调整序列设置与数据库主键同步，最终解决了这一异常。

org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2411)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2874)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
at biz.ProductBiz.addPtype(ProductBiz.java:88)
at servlet.Test.main(Test.java:43)
Caused by: java.sql.BatchUpdateException: ORA-00001: 违反唯一约束条件 (T04.SYS_C0011048)

at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10070)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:213)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)

... 16 more

使用hibernate框架，进行级联添加数据时报错，

看到后面的 Caused by: java.sql.BatchUpdateException: ORA-00001: 违反唯一约束条件 (T04.SYS_C0011048)

这是我的商品类型表映射的配置，我用的主键用的是数据库里的序列

<class name="pojo.PType" table="`S_PTYPE`">
<id name="typeID" type="java.lang.Integer" column="typeid">
<generator class="sequence">
<param name="sequence">seq_ptype</param>
</generator>
</id>
<property name="typeName" type="java.lang.String" column="typename"></property>
<set name="products" cascade="save-update" inverse="true">
<key column="productype"></key>
<one-to-many class="pojo.Product"/>
</set>
</class>