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
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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 | 3 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