org.hibernate.exception.SQLGrammarException: could not execute statement

  1. 0

    Schema Exception Hibernate One to Many

    Stack Overflow | 4 months ago | Hadrian Blackwater
    org.hibernate.exception.SQLGrammarException: could not execute statement
  2. 0

    java.sql.SQLSyntaxErrorException: Unknown column in 'field list'

    Stack Overflow | 4 months ago | Hadrian Blackwater
    java.sql.SQLSyntaxErrorException: Unknown column 'orderDate' in 'field list'
  3. 0

    Hibernate does not create a tables using persistence.xml

    Stack Overflow | 3 weeks ago | user4881671
    java.sql.SQLSyntaxErrorException: Table 'hello.user' doesn't exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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) )]
  6. 0

    Schema Exception Hibernate One to Many

    Stack Overflow | 4 months ago | Hadrian Blackwater
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Unable to execute command [ alter table OrderItem add constraint FK1d77ns82kvwa2hwab9k7xcaog foreign key (order_id) references Order (order_id)]

  1. hoangtranwork 80 times, last 6 months ago
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 (address, name) values ('919 Ridge', 'regular')' at line 1

    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException()
  2. com.mysql.cj
    PreparedStatement.executeUpdate
    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.PreparedStatement.executeInternal(PreparedStatement.java:1827)
    7. com.mysql.cj.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2041)
    8. com.mysql.cj.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:1977)
    9. com.mysql.cj.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:4963)
    10. com.mysql.cj.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1962)
    10 frames
  3. Hibernate
    ResultSetReturnImpl.executeUpdate
    1. org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)
    1 frame
  4. org.hibernate.dialect
    GetGeneratedKeysDelegate.executeAndExtract
    1. org.hibernate.dialect.identity.GetGeneratedKeysDelegate.executeAndExtract(GetGeneratedKeysDelegate.java:57)
    1 frame
  5. Hibernate
    SessionImpl.save
    1. org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:42)
    2. org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2840)
    3. org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3411)
    4. org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)
    5. org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:619)
    6. org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:273)
    7. org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:254)
    8. org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:299)
    9. org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:318)
    10. org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:275)
    11. org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:182)
    12. org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:113)
    13. org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:192)
    14. org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:38)
    15. org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:177)
    16. org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:32)
    17. org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:73)
    18. org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:668)
    19. org.hibernate.internal.SessionImpl.save(SessionImpl.java:660)
    20. org.hibernate.internal.SessionImpl.save(SessionImpl.java:655)
    20 frames
  6. one_to_many
    Runner.main
    1. one_to_many.Runner.main(Runner.java:26)
    1 frame