[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3531) Constraint violation Error

[suman (JIRA)]

Constraint violation Error
--------------------------

                 Key: HHH-3531
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3531
             Project: Hibernate Core
          Issue Type: Bug
          Components: core
    Affects Versions: 3.3.1
         Environment: Spring/Hibernate/Mysql/
            Reporter: suman


Hello All,

I am Using Spring with Hibernate in my web application.I got Syncronize Exception in some Cases.Atually i am updating to table(sno[PK,Auto increment],acno,pan)
In my HBM file i am mentioning sno as increment of generator class.Keen obeservation i am not getting this sort of problem always.In some Time i got this sort of proble,

Log as follows:
INFO   | jvm 2    | 2008/10/15 16:06:25 | 16:06:25,353  WARN JDBCExceptionReporter:71 - SQL Error: 1062, SQLState: 23000
INFO   | jvm 2    | 2008/10/15 16:06:25 | 16:06:25,354 ERROR JDBCExceptionReporter:72 - Duplicate key or integrity constraint violation,  message from server: "Duplicate entry '984041' for key 1"
INFO   | jvm 2    | 2008/10/15 16:06:25 | 16:06:25,355 ERROR AbstractFlushingEventListener:277 - Could not synchronize database state with session
INFO   | jvm 2    | 2008/10/15 16:06:25 | org.hibernate.exception.ConstraintViolationException: could not insert: [com.xxx.model.map]

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira