java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: AK\_ID\_NAMEOFID in statement \[INSERT INTO TBL\_MYSTOREDDATA\_ATTS (ID\_DATA, ATTRIBUTE1) VALUES(?, ?); \]

hsqldb | *anonymous | 9 years ago
  1. 0

    OBJECT type column

    hsqldb | 9 years ago | *anonymous
    java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: AK\_ID\_NAMEOFID in statement \[INSERT INTO TBL\_MYSTOREDDATA\_ATTS (ID\_DATA, ATTRIBUTE1) VALUES(?, ?); \]
  2. 0

    File not sending using openfire file-transfer android client

    Stack Overflow | 2 years ago | Bilbo
    java.sql.SQLException: Unique constraint violation: SYS_IDX_51 in statement [INSERT INTO ofPresence(username, offlinePresence, offlineDate) VALUES(?,?,?)]
  3. 0

    HSQLDB throws Asset failed exception and file io error on db.script.new file during Checkpoint

    Stack Overflow | 1 year ago | developer
    java.sql.SQLException: Assert failed: java.lang.ArrayIndexOutOfBoundsException: 23 in statement [CHECKPOINT]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Adding the same role to the group results in exception in the server log

    YouTrack | 8 years ago
    java.sql.SQLException: Violation of unique constraint SYS_CT_255: duplicate value(s) for column(s) GROUP_ID,ROLE_ID,PROJECT_ID in statement [IN SERT INTO usergroup_roles (GROUP_ID, ROLE_ID, PROJECT_ID) VALUES (?,?,?)]

    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) $$: AK\_ID\_NAMEOFID in statement \[INSERT INTO TBL\_MYSTOREDDATA\_ATTS (ID\_DATA, ATTRIBUTE1) VALUES(?, ?); \]

      at org.hsqldb.jdbc.Util.throwError()
    2. HSQLDB
      jdbcPreparedStatement.execute
      1. org.hsqldb.jdbc.Util.throwError(Unknown Source)
      2. org.hsqldb.jdbc.jdbcPreparedStatement.execute(Unknown Source)
      2 frames
    3. com.myCompany.db
      Main.main
      1. com.myCompany.db.DatabaseFiller.fillTablesFromPortfolios(DatabaseFiller.java:65)
      2. com.myCompany.db.DatabaseFiller.fill(DatabaseFiller.java:35)
      3. com.myCompany.db.Main.run(Main.java:30)
      4. com.myCompany.db.Main.main(Main.java:17)
      4 frames