org.hibernate.tool.schema.spi.CommandAcceptanceException: Unable to execute command [ create table Order ( order_id integer not null auto_increment, address varchar(255), name varchar(255), primary key (order_id) )]

  1. 0

    Schema Exception Hibernate One to Many

    Stack Overflow | 4 months ago | Hadrian Blackwater
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Unable to execute command [ create table Order ( order_id integer not null auto_increment, address varchar(255), name varchar(255), primary key (order_id) )]
  2. 0

    MySQL error: Specified key was too long; max key length is 767 bytes

    GitHub | 3 weeks ago | vrozkovec
    org.polyjdbc.core.exception.SchemaManagerException: [DDL_ERROR] Failed to run DDL: CREATE TABLE jv_commit_property ( property_name VARCHAR(200), property_value VARCHAR(200), commit_fk BIGINT, CONSTRAINT jv_commit_property_pk PRIMARY KEY(commit_fk, property_name), CONSTRAINT jv_commit_property_commit_fk FOREIGN KEY(commit_fk) REFERENCES jv_commit(commit_pk) ) ENGINE = InnoDB
  3. 0

    Schema Exception Hibernate One to Many

    Stack Overflow | 4 months ago | Hadrian Blackwater
    org.hibernate.exception.SQLGrammarException: could not execute statement
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Re: Order by in query

    sqoop-user | 10 months ago | Amit Kumar
    java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; > check the manual that corresponds to your MySQL server version for the > right syntax to use near 'where (1 = 0)' at line 1 Query is: sql : 'select * from sqooptest order by emails where (1 = 0) ' at > org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:138) at > org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106) at > org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:252)
  6. 0

    Re: Order by in query

    sqoop-user | 10 months ago | Amit Kumar
    java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; > check the manual that corresponds to your MySQL server version for the > right syntax to use near 'where (1 = 0)' at line 1 Query is: sql : 'select * from sqooptest order by emails where (1 = 0) ' at > org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:138) at > org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106) at > org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:252)

    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. java.sql.SQLSyntaxErrorException

      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Order ( order_id integer not null auto_increment, address varcha' at line 1

      at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException()
    2. com.mysql.cj
      StatementImpl.execute
      1. com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:686)
      2. com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:663)
      3. com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:653)
      4. com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
      5. com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2041)
      6. com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1994)
      7. com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:890)
      8. com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:788)
      8 frames
    3. org.hibernate.tool
      SchemaManagementToolCoordinator.process
      1. org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:51)
      2. org.hibernate.tool.schema.internal.SchemaMigratorImpl.applySqlString(SchemaMigratorImpl.java:573)
      3. org.hibernate.tool.schema.internal.SchemaMigratorImpl.applySqlStrings(SchemaMigratorImpl.java:557)
      4. org.hibernate.tool.schema.internal.SchemaMigratorImpl.createTable(SchemaMigratorImpl.java:345)
      5. org.hibernate.tool.schema.internal.SchemaMigratorImpl.performMigration(SchemaMigratorImpl.java:257)
      6. org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigration(SchemaMigratorImpl.java:137)
      7. org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigration(SchemaMigratorImpl.java:110)
      8. org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:176)
      9. org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)
      9 frames
    4. Hibernate
      SessionFactoryImpl.<init>
      1. org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:308)
      1 frame
    5. org.hibernate.boot
      SessionFactoryBuilderImpl.build
      1. org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:483)
      1 frame
    6. Hibernate
      Configuration.buildSessionFactory
      1. org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:707)
      2. org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:723)
      2 frames
    7. one_to_many
      Runner.main
      1. one_to_many.Runner.main(Runner.java:15)
      1 frame