MySQL Server version for the right syntax-use near ' Type=innodb ' on line 1

Reprint Please specify Source: http://blog.csdn.net/bettarwang/article/details/40180271

When running a hibernate example, the <property name= "Hibernate.hbm2ddl.auto" >update</property> properties were configured, but the auto-build table was unsuccessful. The error message is:

ERROR:HHH000388:Unsuccessful:create table info_table (ID integer NOT NULL auto_increment, title varchar (255), Content V Archar (255), primary key (ID)) Type=innodb

Error:you has an error in your SQL syntax; Check the manual-corresponds to your MySQL server version for the right syntax-use-near ' Type=innodb ' on line 1

Obviously, this is the version of MySQL problem caused, in fact, before MySQL5.0, TYPE=INNODB is a valid SQL statement, but the use of MySQL5.5 version, Type=innodb no longer valid.

The workaround is to modify the dialect attribute in the Hibernate.cfg.xml to

<property name= "dialect" >org.hibernate.dialect.MySQLInnoDBDialect</property> amended to

<property name= "Hibernate.dialect" >org.hibernate.dialect.MySQL5InnoDBDialect</property>

Run again and find that the table can be built automatically.

MySQL Server version for the right syntax-use near ' Type=innodb ' on line 1