一：今天遇到一個詭異的問題，就是關于hibernate3.x實現表結構自動創建，一般我們在用Struts2，Hibernate3.x，Spring3.x搭建框架，尤其在開發階段都希望在啟動Web容器時就可以根據Bean實體自動創建數據表結構，但是今天發現不行，經過查找，最終解決，現在記錄一下：

二：首先是實體Bean類：這里我們以User.java為例：

User.java

package net.lampbrother.survey.domain;import java.util.Date;
import java.util.HashSet;
import java.util.Set;/*** 用戶實體*/
public class User {private Integer id;private String email;private String password;private String nickName;private Date regDate = new Date();private Set<Survey> surveys = new HashSet<Survey>();public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getEmail() {return email;}public void setEmail(String email) {this.email = email;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}public String getNickName() {return nickName;}public void setNickName(String nickName) {this.nickName = nickName;}public Date getRegDate() {return regDate;}public void setRegDate(Date regDate) {this.regDate = regDate;}public Set<Survey> getSurveys() {return surveys;}public void setSurveys(Set<Survey> surveys) {this.surveys = surveys;}}

三：接下來是User.hbm.xml文件：

<?xml VERSION="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><hibernate-mapping><class NAME="net.lampbrother.survey.domain.User" TABLE="USERS"><id NAME="id" TYPE="java.lang.Integer"><COLUMN NAME="USER_ID" /><generator class="native" /></id><property NAME="email" TYPE="java.lang.String"><COLUMN NAME="EMAIL" /></property><property NAME="password" TYPE="java.lang.String"><COLUMN NAME="PASSWORD" /></property><property NAME="nickName" TYPE="java.lang.String"><COLUMN NAME="NICK_NAME" /></property><property NAME="regDate" TYPE="java.util.Date"><COLUMN NAME="REG_DATE" /></property></class></hibernate-mapping>

四：接下來就是hibernate的配置文件：hibernate.cfg.xml

<?xml VERSION="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC"-//Hibernate/Hibernate Configuration DTD 3.0//EN""http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration><SESSION-factory><property NAME="show_sql">TRUE</property><property NAME="format_sql">TRUE</property><property NAME="hbm2ddl.auto">UPDATE</property><!-- 上面的這個不能自動創建表結構 --><!-- 根據Bean自動生成數據庫表,MySql5.5以后要使用org.hibernate.dialect.MySQL5InnoDBDialect才能創建成功！ --><!-- <property name="dialect">org.hibernate.dialect.MySQLInnoDBDialect</property> --><property NAME="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property><property NAME="jdbc.fetch_size">200</property><property NAME="jdbc.batch_size">50</property>    <!-- 加入 Hibernate 映射文件 --><mapping resource="net/lampbrother/survey/domain/User.hbm.xml"/></SESSION-factory></hibernate-configuration>

五：究其原因是：MySQL5.5版本以后就不能用：org.hibernate.dialect.MySQLInnoDBDialect方言來實現自動建表了，必須改用：org.hibernate.dialect.MySQL5InnoDBDialect來實現自動建表。