org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_PK_10030 table: DATA

hsqldb | disbj | 5 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    MVCC rollback issue: readExistingData failed

    hsqldb | 5 years ago | disbj
    org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_PK_10030 table: DATA
  2. 0

    Endeca CAS service not running.

    Oracle Community | 4 years ago | GK MISHRA
    com.endeca.itl.ItlRuntimeException: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [UPDATE MODULE_SPECS SET OBJECT_XML = ? WHERE OBJECT_ID = ?]; integrity constraint violation: unique constraint or index violation; SYS_PK_10040 table: MODULE_SPECS; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10040 table: MODULE_SPECS
  3. 0

    EditView: no validation for fixed format fields

    GitHub | 4 years ago | ikostenko
    org.hsqldb.HsqlException: data exception: numeric value out of range
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SQL initialization with "data.sql" comes too late if using hibernate DDL auto as well

    GitHub | 3 years ago | mihkels
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration': Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement at line 1 of resource URL [file:/C:/projects/personal/sport-store/target/classes/data.sql]: INSERT INTO category (id, name) VALUES (1, 'Watersports'); nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: CATEGORY
  6. 0

    JPA persist fails with new compound key existing relation entities

    Stack Overflow | 3 years ago | anterosalonen
    org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.ConstraintViolationException: could not execute statement; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement

  1. jpvee 4 times, last 2 months ago
  2. kjhdofjosvs 1 times, last 3 months ago
  3. andyglick 2 times, last 3 months ago
  4. marcbouvierdav 1 times, last 4 months ago
  5. WoodenDoors 67 times, last 10 months ago
87 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. org.hsqldb.HsqlException

    integrity constraint violation: unique constraint or index violation; SYS_PK_10030 table: DATA

    at org.hsqldb.error.Error.error()
  2. HyperSQL Database
    Error.error
    1. org.hsqldb.error.Error.error(Error.java:134)
    1 frame
  3. HSQLDB
    JDBCStatement.execute
    1. org.hsqldb.Constraint.getException(Constraint.java:872)
    2. org.hsqldb.index.IndexAVLMemory.insert(IndexAVLMemory.java:236)
    3. org.hsqldb.persist.RowStoreAVL.indexRow(RowStoreAVL.java:171)
    4. org.hsqldb.Table.insertData(Table.java:2669)
    5. org.hsqldb.Table.insertFromScript(Table.java:2658)
    6. org.hsqldb.scriptio.ScriptReaderText.readExistingData(ScriptReaderText.java:186)
    7. org.hsqldb.scriptio.ScriptReaderBase.readAll(ScriptReaderBase.java:64)
    8. org.hsqldb.persist.Log.processScript(Log.java:744)
    9. org.hsqldb.persist.Log.open(Log.java:171)
    10. org.hsqldb.persist.Logger.openPersistence(Logger.java:364)
    11. org.hsqldb.Database.reopen(Database.java:227)
    12. org.hsqldb.Database.close(Database.java:574)
    13. org.hsqldb.StatementCommand.getResult(StatementCommand.java:854)
    14. org.hsqldb.StatementCommand.execute(StatementCommand.java:211)
    15. org.hsqldb.Session.executeCompiledStatement(Session.java:1282)
    16. org.hsqldb.Session.executeDirectStatement(Session.java:1214)
    17. org.hsqldb.Session.execute(Session.java:1000)
    18. org.hsqldb.jdbc.JDBCStatement.fetchResult(JDBCStatement.java:1830)
    19. org.hsqldb.jdbc.JDBCStatement.execute(JDBCStatement.java:636)
    19 frames
  4. Unknown
    TestHSQLDB.main
    1. TestHSQLDB.main(TestHSQLDB.java:123)
    1 frame