hibernate4连接mysql自动创建表之错误

2019独角兽企业重金招聘Python工程师标准>>>

最近一个项目用的ssh，我从svn上checkout项目之后启动(配置的是hibernate.hbm2ddl.auto=update)，结果表没有自动生成(表不存在)，然后看控制台，控制台提示创建表失败，把创建语句拿出来是：

HHH000388: Unsuccessful: create table t_user (user_id bigint not null auto_increment, card_number varchar(30), card_type varchar(20), company_name varchar(200), email varchar(100), gender varchar(100) not null, identity varchar(20), job_name varchar(60), mobile varchar(30) not null, password varchar(100) not null, real_name varchar(100) not null, primary key (user_id)) type=InnoDB

2014-11-10 10:27:10,749 ERROR (org.hibernate.tool.hbm2ddl.SchemaUpdate:237) - 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 ‍'type=InnoDB'‍ at line 14

2014-11-10 10:27:10,756 ERROR (org.hibernate.tool.hbm2ddl.SchemaUpdate:236) - HHH000388: Unsuccessful: create table t_word (word_id bigint not null auto_increment, content longtext not null, create_date datetime, modify_date datetime, title varchar(100) not null, author_id bigint, primary key (word_id)) type=InnoDB

2014-11-10 10:27:10,763 ERROR (org.hibernate.tool.hbm2ddl.SchemaUpdate:237) - 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 'type=InnoDB' at line 9

2014-11-10 10:27:10,767 ERROR (org.hibernate.tool.hbm2ddl.SchemaUpdate:236) - HHH000388: Unsuccessful: create table t_wordreply (reply_id bigint not null auto_increment, content longtext not null, reply_date datetime, replier_id bigint, word_id bigint, primary key (reply_id)) type=InnoDB

可以看到自后都是type=InnoDB,网上搜索了之后，原来是type=InnoDB 是5.0之前使用的，我的数据库是5.5的

这个时候需要把hibernate中mysql的方言改一下，

原来的：hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

改成：hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

转载于:https://my.oschina.net/u/163187/blog/342583