org.hibernate.tool.schema.spi.CommandAcceptanceException: Unable to execute command [drop sequence ALIVE_ID_SEQUENCE]

GitHub | fviale | 4 months ago
  1. 0

    Database warnings when starting the scheduler

    GitHub | 4 months ago | fviale
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Unable to execute command [drop sequence ALIVE_ID_SEQUENCE]
  2. 0

    validate() reports exception about attempting to re-create existing view

    GitHub | 2 years ago | GoogleCodeExporter
    java.sql.SQLSyntaxErrorException: object name already exists: USER_EX68673 in statement [CREATE VIEW USER_EX68673 AS SELECT * FROM CSV_TABLE56271]
  3. 0

    Test failure (ordering problem with database)

    GitHub | 2 years ago | dsyer
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateJpaAutoConfiguration': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private javax.sql.DataSource org.springframework.boot.autoconfigure.orm.jpa.JpaBaseConfiguration.dataSource; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class org.springframework.boot.autoconfigure.jdbc.EmbeddedDataSourceConfiguration: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSourceInitializer': 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:/home/dsyer/dev/boot/boot/spring-boot-autoconfigure/target/test-classes/schema.sql]: CREATE TABLE BAR ( id INTEGER IDENTITY PRIMARY KEY, name VARCHAR(30), ); nested exception is java.sql.SQLSyntaxErrorException: object name already exists: BAR in statement [CREATE TABLE BAR ( id INTEGER IDENTITY PRIMARY KEY, name VARCHAR(30), )]
  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

    Why does Spring's <jdbc:embedded-database> throw a SQLSyntaxErrorException?

    Stack Overflow | 3 years ago | Koohoolinn
    java.lang.IllegalStateException: Failed to load ApplicationContext

  1. andyglick 2 times, last 3 weeks ago
  2. marcbouvierdav 1 times, last 1 month ago
  3. WoodenDoors 67 times, last 7 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

    user lacks privilege or object not found: ALIVE_ID_SEQUENCE

    at org.hsqldb.error.Error.error()
  2. HyperSQL Database
    Error.error
    1. org.hsqldb.error.Error.error(Unknown Source)
    2. org.hsqldb.error.Error.error(Unknown Source)
    2 frames
  3. HSQLDB
    JDBCStatement.execute
    1. org.hsqldb.StatementSchema.getResult(Unknown Source)
    2. org.hsqldb.StatementSchema.execute(Unknown Source)
    3. org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    4. org.hsqldb.Session.executeDirectStatement(Unknown Source)
    5. org.hsqldb.Session.execute(Unknown Source)
    6. org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    7. org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    7 frames
  4. HikariCP-java6
    StatementJavassistProxy.execute
    1. com.zaxxer.hikari.proxy.StatementProxy.execute(StatementProxy.java:83)
    2. com.zaxxer.hikari.proxy.StatementJavassistProxy.execute(StatementJavassistProxy.java)
    2 frames
  5. org.hibernate.tool
    SchemaManagementToolCoordinator.process
    1. org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:51)
    2. org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlString(SchemaDropperImpl.java:370)
    3. org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlStrings(SchemaDropperImpl.java:355)
    4. org.hibernate.tool.schema.internal.SchemaDropperImpl.dropFromMetadata(SchemaDropperImpl.java:245)
    5. org.hibernate.tool.schema.internal.SchemaDropperImpl.performDrop(SchemaDropperImpl.java:153)
    6. org.hibernate.tool.schema.internal.SchemaDropperImpl.doDrop(SchemaDropperImpl.java:125)
    7. org.hibernate.tool.schema.internal.SchemaDropperImpl.doDrop(SchemaDropperImpl.java:111)
    8. org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:137)
    9. org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:64)
    9 frames
  6. Hibernate
    SessionFactoryImpl.<init>
    1. org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:458)
    1 frame
  7. org.hibernate.boot
    SessionFactoryBuilderImpl.build
    1. org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:465)
    1 frame
  8. Hibernate
    Configuration.buildSessionFactory
    1. org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:708)
    2. org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:724)
    2 frames
  9. org.ow2.proactive
    RMCore.<init>
    1. org.ow2.proactive.resourcemanager.db.RMDBManager.<init>(RMDBManager.java:158)
    2. org.ow2.proactive.resourcemanager.db.RMDBManager.createUsingProperties(RMDBManager.java:118)
    3. org.ow2.proactive.resourcemanager.db.RMDBManager.access$000(RMDBManager.java:65)
    4. org.ow2.proactive.resourcemanager.db.RMDBManager$LazyHolder.<clinit>(RMDBManager.java:77)
    5. org.ow2.proactive.resourcemanager.db.RMDBManager.getInstance(RMDBManager.java:84)
    6. org.ow2.proactive.resourcemanager.core.account.RMAccountsManager.<init>(RMAccountsManager.java:68)
    7. org.ow2.proactive.resourcemanager.core.RMCore.<init>(RMCore.java:254)
    7 frames
  10. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:422)
    4 frames
  11. org.objectweb.proactive
    ActiveBody.<init>
    1. org.objectweb.proactive.core.mop.ConstructorCallImpl.execute(ConstructorCallImpl.java:136)
    2. org.objectweb.proactive.core.body.ActiveBody.<init>(ActiveBody.java:105)
    2 frames
  12. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:422)
    4 frames
  13. org.objectweb.proactive
    UniversalBodyProxy.<init>
    1. org.objectweb.proactive.core.mop.ConstructorCallImpl.execute(ConstructorCallImpl.java:136)
    2. org.objectweb.proactive.core.runtime.ProActiveRuntimeImpl.createBody(ProActiveRuntimeImpl.java:883)
    3. org.objectweb.proactive.core.body.proxy.UniversalBodyProxy.createLocalBody(UniversalBodyProxy.java:245)
    4. org.objectweb.proactive.core.body.proxy.UniversalBodyProxy.<init>(UniversalBodyProxy.java:160)
    4 frames
  14. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:422)
    4 frames
  15. org.objectweb.proactive
    PAActiveObject.newActive
    1. org.objectweb.proactive.core.mop.MOP.createProxyObject(MOP.java:860)
    2. org.objectweb.proactive.core.mop.MOP.newInstance(MOP.java:280)
    3. org.objectweb.proactive.core.mop.MOP.newInstance(MOP.java:184)
    4. org.objectweb.proactive.core.mop.MOP.createStubObject(MOP.java:1179)
    5. org.objectweb.proactive.core.mop.MOP.createStubObject(MOP.java:1172)
    6. org.objectweb.proactive.api.PAActiveObject.newActive(PAActiveObject.java:444)
    7. org.objectweb.proactive.api.PAActiveObject.newActive(PAActiveObject.java:218)
    7 frames
  16. org.ow2.proactive
    RMFactory.startLocal
    1. org.ow2.proactive.resourcemanager.RMFactory.startLocal(RMFactory.java:112)
    2. org.ow2.proactive.resourcemanager.RMFactory.startLocal(RMFactory.java:188)
    2 frames
  17. functionaltests.utils
    SchedulerStartForFunctionalTest$1.run
    1. functionaltests.utils.SchedulerStartForFunctionalTest$1.run(SchedulerStartForFunctionalTest.java:112)
    1 frame