hibernate4串連mysql自動建立表之錯誤

標籤：

我在學習Hibernate的過程中，遇到了這樣一個錯誤：JUnit測試通過，但是資料庫中卻沒有建立一個表，控制台的錯誤資訊如下：

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

 

hibernate4串連mysql自動建立表之錯誤