org.apache.ddlutils.DatabaseOperationException: Error while executing SQL ALTER TABLE PROCESS DROP CONSTRAINT PROCESS_FK_CURRENTACTIVITYID_ACTIVITYDEFINITION

hsqldb | erolmaj2 | 7 months 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

    DROP CONSTRAINT causes SQLIntegrityConstraintViolationException

    hsqldb | 7 months ago | erolmaj2
    org.apache.ddlutils.DatabaseOperationException: Error while executing SQL ALTER TABLE PROCESS DROP CONSTRAINT PROCESS_FK_CURRENTACTIVITYID_ACTIVITYDEFINITION
  2. 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
  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

    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
  6. 0

    Using embedded database with Flyway and jOOQ in Maven for continuous integration

    Stack Overflow | 2 years ago | user2957009
    org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@1096ec89[file =...db/db.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2015-02-09 03:56:15 heartbeat - read: -863 ms.
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_11827 table: PROCESS

    at org.hsqldb.error.Error.error()
  2. HyperSQL Database
    Error.error
    1. org.hsqldb.error.Error.error(Error.java:137)
    1 frame
  3. HSQLDB
    JDBCStatement.executeUpdate
    1. org.hsqldb.Constraint.getException(Constraint.java:883)
    2. org.hsqldb.index.IndexAVLMemory.insert(IndexAVLMemory.java:233)
    3. org.hsqldb.persist.RowStoreAVL.indexRow(RowStoreAVL.java:241)
    4. org.hsqldb.persist.RowStoreAVL.moveData(RowStoreAVL.java:564)
    5. org.hsqldb.TableWorks.moveData(TableWorks.java:1382)
    6. org.hsqldb.TableWorks.dropConstraint(TableWorks.java:1030)
    7. org.hsqldb.SchemaManager.dropConstraint(SchemaManager.java:1525)
    8. org.hsqldb.StatementSchema.getResult(StatementSchema.java:888)
    9. org.hsqldb.StatementSchema.execute(StatementSchema.java:274)
    10. org.hsqldb.Session.executeCompiledStatement(Session.java:1384)
    11. org.hsqldb.Session.executeDirectStatement(Session.java:1259)
    12. org.hsqldb.Session.execute(Session.java:1024)
    13. org.hsqldb.jdbc.JDBCStatement.fetchResult(JDBCStatement.java:1789)
    14. org.hsqldb.jdbc.JDBCStatement.executeUpdate(JDBCStatement.java:208)
    14 frames
  4. org.apache.ddlutils
    PlatformImplBase.evaluateBatch
    1. org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:323)
    2. org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:279)
    2 frames
  5. com.ericsson.cas
    RemoteUserResetPasswordListPresenterIT.init
    1. com.ericsson.cas.db.dbunit.DbLoader.executeDataXMLOperation(DbLoader.java:134)
    2. com.ericsson.cas.componenttest.dbinitializer.PerCaseDbInitializerSpringImpl.initPerCaseDb(PerCaseDbInitializerSpringImpl.java:45)
    3. com.ericsson.cas.functest.core.db.DbInitalizer.initPerCaseDb(DbInitalizer.java:57)
    4. com.ericsson.cas.functest.core.CasSystemTest.initDb(CasSystemTest.java:90)
    5. com.ericsson.cas.functest.core.CasSystemTest.init(CasSystemTest.java:74)
    6. com.ericsson.cas.inttest.awm.RemoteUserResetPasswordListPresenterIT.init(RemoteUserResetPasswordListPresenterIT.java:83)
    6 frames
  6. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:606)
    4 frames
  7. JUnit
    FrameworkMethod.invokeExplosively
    1. org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
    2. org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
    3. org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
    3 frames
  8. Main
    MockFrameworkMethod.invokeExplosively
    1. mockit.integration.junit4.internal.JUnit4TestRunnerDecorator.invokeExplosively(JUnit4TestRunnerDecorator.java:44)
    2. mockit.integration.junit4.internal.MockFrameworkMethod.invokeExplosively(MockFrameworkMethod.java:37)
    2 frames
  9. JUnit
    RunBefores.evaluate
    1. org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java)
    2. org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24)
    2 frames
  10. Spring TestContext
    RunBeforeTestMethodCallbacks.evaluate
    1. org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)
    1 frame
  11. JUnit
    RunAfters.evaluate
    1. org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
    1 frame
  12. Spring TestContext
    RunAfterTestMethodCallbacks.evaluate
    1. org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)
    1 frame
  13. JUnit
    FailOnTimeout$StatementThread.run
    1. org.junit.internal.runners.statements.FailOnTimeout$StatementThread.run(FailOnTimeout.java:74)
    1 frame