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