MySQL Server version for the right syntax-use near & #39;type=innodb& #39; At line 1

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

The <property name= "Hibernate.hbm2ddl.auto" >update</property> properties were configured when performing a demo sample of Hibernate, but the initiative to build the 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 MySQL version number problem caused, in fact, in MySQL5.0 once, TYPE=INNODB is a valid SQL statement, but its own MySQL5.5 version number, Type=innodb no longer valid.

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

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

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

Once again, I found that I was able to build the table on my own initiative.

MySQL Server version for the right syntax-use near & #39;type=innodb& #39; At line 1