org hibernate exception ConstraintViolationException Could not execute JDBC batch update

Question

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   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 lt Attendee gt  attendees   new HashSet lt Attendee gt  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    lt hibernate-mapping package  com practice hibernate vo  gt       lt class name  Event  table  event  gt           lt id name  eventId  column  eventId  type  long  gt               lt generator class  assigned    gt           lt  id gt            lt property name  eventName  type  string  length  100    gt           lt property name  startDate  type  date    gt            lt set name  attendees  cascade  all  gt               lt key column  attendeeId    gt               lt one-to-many class  Attendee    gt           lt  set gt       lt  class gt   lt  hibernate-mapping gt    hibernate cfg xml   lt hibernate-configuration gt       lt session-factory gt           lt property name  connection driver class  gt com mysql jdbc Driver lt  property gt           lt property name  connection url  gt jdbc mysql   localhost test lt  property gt           lt property name  connection username  gt root lt  property gt           lt property name  connection password  gt  lt  property gt           lt property name  connection autocommit  gt false lt  property gt            lt property name  dialect  gt org hibernate dialect MySQLDialect lt  property gt           lt property name  show sql  gt true lt  property gt            lt mapping resource  com practice hibernate vo Event hbm xml  gt  lt  mapping gt           lt mapping resource  com practice hibernate vo Attendee hbm xml  gt  lt  mapping gt       lt  session-factory gt   lt  hibernate-configuration gt

User · Accepted Answer

Your Event hbm xml says    lt set name  attendees  cascade  all  gt       lt key column  attendeeId    gt       lt one-to-many class  Attendee    gt   lt  set gt    In plain english  this means that the column Attendee attendeeId is the foreign key for the association attendees and points to the primary key of 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   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

User · Answer

You can find your sample code completely here  http   www java2s com Code Java Hibernate OneToManyMappingbasedonSet htm  Have a look and check the differences  specially the even id in      lt set name  attendees  cascade  all  gt       lt key column  event id   gt       lt one-to-many class  Attendee   gt   lt  set gt

User · Answer

You may need to handle javax persistence RollbackException

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

Examples related to java

Examples related to mysql

Examples related to hibernate

Examples related to mysql-error-1062