org.hibernate.tool.schema.spi.CommandAcceptanceException

Unable to execute command [alter table SINGULARKONSTRAINT drop constraint FKj7t94rc7oab2i1kmur42hjc98]

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web26

  • via Hibernate JIRA by Will Darby, 1 year ago
    Unable to execute command [alter table SINGULARKONSTRAINT drop constraint FKj7t94rc7oab2i1kmur42hjc98]
  • Unable to execute command [ alter table board drop foreign key FKcefyg893q4c26nvw7uus84ts3]
  • Unable to execute command [ alter table QWE drop foreign key FK5f4s5qg3vma47jthit51i7wvy]
  • Stack trace

    • org.hibernate.tool.schema.spi.CommandAcceptanceException: Unable to execute command [alter table SINGULARKONSTRAINT drop constraint FKj7t94rc7oab2i1kmur42hjc98] at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:63) at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlString(SchemaDropperImpl.java:370) at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlStrings(SchemaDropperImpl.java:355) at org.hibernate.tool.schema.internal.SchemaDropperImpl.applyConstraintDropping(SchemaDropperImpl.java:327) at org.hibernate.tool.schema.internal.SchemaDropperImpl.dropFromMetadata(SchemaDropperImpl.java:229) at org.hibernate.tool.schema.internal.SchemaDropperImpl.performDrop(SchemaDropperImpl.java:153) at org.hibernate.tool.schema.internal.SchemaDropperImpl.doDrop(SchemaDropperImpl.java:125) at org.hibernate.tool.schema.internal.SchemaDropperImpl.doDrop(SchemaDropperImpl.java:111) at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:137) at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65) at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:308) at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:483) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:707) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:723) Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: PUBLIC.SINGULARKONSTRAINT at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:51) ... 14 more Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: PUBLIC.SINGULARKONSTRAINT at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.SchemaManager.getUserTable(Unknown Source) at org.hsqldb.ParserDDL.compileAlterTable(Unknown Source) at org.hsqldb.ParserDDL.compileAlter(Unknown Source) at org.hsqldb.ParserCommand.compilePart(Unknown Source) at org.hsqldb.ParserCommand.compileStatements(Unknown Source) at org.hsqldb.Session.executeDirectStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 22 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    222 times, 4 weeks ago
    1791 times, 6 months ago
    7 times, 7 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    92 more bugmates