java.sql.SQLException: Violation of unique index: Violation of unique index: SYS\_PK\_STUDENTS in statement \[INSERT INTO "STUDENTS" VALUES(123456789,'shmoe','joe','g',1)\]

hsqldb | program_user | 1 decade ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Database startup issue

    hsqldb | 1 decade ago | program_user
    java.sql.SQLException: Violation of unique index: Violation of unique index: SYS\_PK\_STUDENTS in statement \[INSERT INTO "STUDENTS" VALUES(123456789,'shmoe','joe','g',1)\]
  2. 0

    OutOfMemoryError when writing to cachedTable

    hsqldb | 8 years ago | wason
    java.sql.SQLException: error in script file line: 57 out of memory
  3. 0

    hsqldb bypass authentication: reset forgotten user and password

    Stack Overflow | 5 years ago | GreyCat
    java.sql.SQLException: User not found: SA
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JDO - datanucleus - HSQL error

    Stack Overflow | 5 years ago | Aniruddha
    java.sql.SQLException: socket creation error

    5 unregistered visitors
    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 index: Violation of unique index: SYS\_PK\_STUDENTS in statement \[INSERT INTO "STUDENTS" VALUES(123456789,'shmoe','joe','g',1)\]

      at org.hsqldb.Trace.getError()
    2. HSQLDB
      jdbcDriver.connect
      1. org.hsqldb.Trace.getError(Unknown Source)
      2. org.hsqldb.Log.runScript(Unknown Source)
      3. org.hsqldb.Log.open(Unknown Source)
      4. org.hsqldb.Database$Logger.openLog(Unknown Source)
      5. org.hsqldb.Database.open(Unknown Source)
      6. org.hsqldb.Database.<init>(Unknown Source)
      7. org.hsqldb.jdbcConnection.openStandalone(Unknown Source)
      8. org.hsqldb.jdbcConnection.<init>(Unknown Source)
      9. org.hsqldb.jdbcDriver.connect(Unknown Source)
      9 frames
    3. Java RT
      DriverManager.getConnection
      1. java.sql.DriverManager.getConnection(Unknown Source)
      2. java.sql.DriverManager.getConnection(Unknown Source)
      2 frames