org.hsqldb.HsqlException: error in script file line: 49 org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_PK_10030 table: DATA

hsqldb | disbj | 6 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

    MVCC rollback issue: readExistingData failed

    hsqldb | 6 years ago | disbj
    org.hsqldb.HsqlException: error in script file line: 49 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

    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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    User lacks privilege or object not found WITH JUnit

    codedmi.com | 1 year ago
    java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: GROUP
  6. 0

    EditView: no validation for fixed format fields

    GitHub | 5 years ago | ikostenko
    org.hsqldb.HsqlException: data exception: numeric value out of range

  1. marcbouvierdav 12 times, last 3 weeks ago
  2. Axelo 2 times, last 4 weeks ago
  3. jpvee 4 times, last 4 months ago
  4. kjhdofjosvs 1 times, last 5 months ago
  5. andyglick 2 times, last 5 months ago
1 more registered users
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