java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS\_CT\_51 in statement \[INSERT INTO registrations (primary\_key\_id, user\_id) VALUES (?,?)\] at org.hsqldb.jdbc.Util.throwerror(UNknown Source)

hsqldb | acsc33 | 10 years ago
  1. 0

    SQL: Violation of unique constraint $$

    hsqldb | 10 years ago | acsc33
    java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS\_CT\_51 in statement \[INSERT INTO registrations (primary\_key\_id, user\_id) VALUES (?,?)\] at org.hsqldb.jdbc.Util.throwerror(UNknown Source)
  2. 0

    Hibernate Community • View topic - Exception not throw (java.sql.SQLException)

    hibernate.org | 4 months ago
    java.sql.SQLException: Integrity constraint violation: UG_G_FKEY table: NOM_GROUP in statement [insert into nom_user_group (user_id, group_id) values (30, 1)]
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Errors after DataIntegrityViolationException

    springframework | 1 decade ago | garethmorgan
    java.sql.SQLException: Violation of unique index: SYS\_IDX\_2 in statement \[insert into users (userId, password, name, email, uid) values ('gm2', 'gm2', 'G2 Morgan', 'gaz@test.com', 3)\]
  5. 0

    Cause: org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3] Stack Trace: [hide] org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3] java.sql.SQLException: Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.delete(EntityPersister.java:598) at net.sf.hibernate.impl.ScheduledDeletion.execute(ScheduledDeletion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2382) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2340) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2204) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)

    Atlassian JIRA | 1 decade ago | Dave Loeng [Atlassian]
    java.sql.SQLException: Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3]

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS\_CT\_51 in statement \[INSERT INTO registrations (primary\_key\_id, user\_id) VALUES (?,?)\] at org.hsqldb.jdbc.Util.throwerror(UNknown Source)

      at org.hsqldb.jdbcPreparedStatement.executeUpdate()
    2. HSQLDB
      jdbcPreparedStatement.executeUpdate
      1. org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source)
      1 frame