Java org.hibernate.exception.ConstraintViolationException：无法执行 JDBC 批量更新
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/3595065/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
提问by Bashu
I get below mentioned stack trace though the data gets inserted successfully.
尽管数据已成功插入，但我得到了下面提到的堆栈跟踪。
Hibernate: select attendee_.attendeeId, attendee_.attendeeName as attendee2_1_ from attendee attendee_ where attendee_.attendeeId=?
Hibernate: select attendee_.attendeeId, attendee_.attendeeName as attendee2_1_ from attendee attendee_ where attendee_.attendeeId=?
Hibernate: insert into event (eventName, startDate, eventId) values (?, ?, ?)
Hibernate: insert into attendee (attendeeName, attendeeId) values (?, ?)
Hibernate: insert into attendee (attendeeName, attendeeId) values (?, ?)
Hibernate: update attendee set attendeeId=? where attendeeId=?
Hibernate: update attendee set attendeeId=? where attendeeId=?
Aug 29, 2010 7:39:10 PM org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 1062, SQLState: 23000
Aug 29, 2010 7:39:10 PM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Duplicate entry '11' for key 'PRIMARY'
Aug 29, 2010 7:39:10 PM org.hibernate.event.def.AbstractFlushingEventListener performExecutions
SEVERE: Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:144)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:980)
at com.practice.hibernate.basic.BasicOperations.main(BasicOperations.java:51)
Caused by: java.sql.BatchUpdateException: Duplicate entry '11' for key 'PRIMARY'
at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
... 6 more
Exception in thread "main" org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:144)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:980)
at com.practice.hibernate.basic.BasicOperations.main(BasicOperations.java:51)
Caused by: java.sql.BatchUpdateException: Duplicate entry '11' for key 'PRIMARY'
at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
... 6 more
Please note:
请注意：
a) My db has no records currently b) Data gets inserted into DB successfully.
a) 我的数据库目前没有记录 b) 数据成功插入到数据库中。
Here I am trying to persist an Event object which contains two Attendee Objects. That is all.
在这里，我试图保留一个包含两个参加者对象的事件对象。就这些。
My Test Class:
我的测试班：
public static void main(String[] args) {
Session session = HibernateRuntime.getSession();
try {
Set<Attendee> attendees = new HashSet<Attendee>(2);
Attendee attendee = new Attendee();
attendee.setAttendeeId(3);
attendee.setAttendeeName("Baswanth Rao");
Attendee attendee1 = new Attendee();
attendee1.setAttendeeId(4);
attendee1.setAttendeeName("Razi Ahmed");
attendees.add(attendee);
attendees.add(attendee1);
Event event = new Event();
event.setEventId(11);
event.setEventName("Initiatives Workshop 3");
event.setStartDate(new Date());
event.setAttendees(attendees);
session.save(event);
session.flush();
} finally {
session.close();
}
}
Event.hbm.xml:
事件.hbm.xml：
<hibernate-mapping package="com.practice.hibernate.vo">
<class name="Event" table="event">
<id name="eventId" column="eventId" type="long">
<generator class="assigned" />
</id>
<property name="eventName" type="string" length="100" />
<property name="startDate" type="date" />
<set name="attendees" cascade="all">
<key column="attendeeId" />
<one-to-many class="Attendee" />
</set>
</class>
</hibernate-mapping>
hibernate.cfg.xml
休眠文件.cfg.xml
<hibernate-configuration>
<session-factory>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost/test</property>
<property name="connection.username">root</property>
<property name="connection.password"></property>
<property name="connection.autocommit">false</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="show_sql">true</property>
<mapping resource="com/practice/hibernate/vo/Event.hbm.xml"></mapping>
<mapping resource="com/practice/hibernate/vo/Attendee.hbm.xml"></mapping>
</session-factory>
</hibernate-configuration>
采纳答案by meriton
Your Event.hbm.xml says:
您的 Event.hbm.xml 说：
<set name="attendees" cascade="all">
<key column="attendeeId" />
<one-to-many class="Attendee" />
</set>
In plain english, this means that the column Attendee.attendeeIdis the foreign keyfor the association attendeesand points to the primary key of Event.
通俗地说，这意味着该列Attendee.attendeeId是关联的外键attendees并指向 的主键Event。
When you add those Attendees to the event, hibernate updates the foreign key to express the changed association. Since that same column is also the primary key of Attendee, this violates the primary key constraint.
当您将这些参加者添加到事件中时，hibernate 会更新外键以表示已更改的关联。由于同一列也是参加者的主键，这违反了主键约束。
Since an Attendee's identity and event participation are independent, you should use separate columns for the primary and foreign key.
由于参加者的身份和事件参与是独立的，您应该为主键和外键使用单独的列。
Edit: The selects might be because you don't appear to have a version property configured, making it impossible for hibernate to know whether the attendees already exists in the database (they might have been loaded in a previous session), so hibernate emits selects to check. As for the update statements, it was probably easier to implement that way. If you want to get rid of these separate updates, I recommend mapping the association from both ends, and declare the Event-end as inverse.
编辑：选择可能是因为您似乎没有配置版本属性，使 hibernate 无法知道数据库中是否已存在参与者（他们可能已在上一个会话中加载），因此 hibernate 发出选择去检查。至于更新语句，以这种方式实现可能更容易。如果你想摆脱这些单独的更新，我建议从两端映射关联，并将Event-end声明为inverse.
回答by mhshams
You can find your sample code completely here: http://www.java2s.com/Code/Java/Hibernate/OneToManyMappingbasedonSet.htm
您可以在这里完整地找到您的示例代码：http: //www.java2s.com/Code/Java/Hibernate/OneToManyMappingbasedonSet.htm
Have a look and check the differences. specially the even_id in :
看看并检查差异。特别是 even_id 中的：
<set name="attendees" cascade="all">
<key column="event_id"/>
<one-to-many class="Attendee"/>
</set>
回答by waqar
You may need to handle javax.persistence.RollbackException
您可能需要处理 javax.persistence.RollbackException
