Java EE Hibernate exception Resolution: Org.hibernate.exception.SQLGrammarException:could not EXECUTE statement

Essential Reason: A configured Java Bean with syntax errors in SQL statements generated automatically by hibernate

The reasons are as follows:

Scenario 1: There is a conflict between the field name/table name and the database keyword

Situation 2. MySQL5.0 later with MySQL5.0 previous transaction engine InnoDB configuration subtly different

Solution:

// after MySQL 5.0 "engine = InnoDB"<property name="hibernate.dialect"> Org.hibernate.dialect.mysql5innodbdialect</property>//nysql 5.0 "type = InnoDB"< Property Name="hibernate.dialect">org.hibernate.dialect.mysqlinnodbdialect</ Property>

Java EE Hibernate exception Resolution: Org.hibernate.exception.SQLGrammarException:could not EXECUTE statement