关于配置了数据库方言为MySQLInnoDBDialect后Hibernate不能自动建表的问题

- 日理万妓 2022-07-14 07:49 120阅读 0赞

当需要使用支持事务的数据库方言，并且使用了mysql 5.5及以上版本时，需要将数据库方言配置为

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

注意是MySQL5InnoDBDialect，而不是MySQLInnoDBDialect，否则不能自动建表。

另外附上各种数据库对应的方言：

<table style="color:rgb(0,0,0); font-family:Arial; font-size:14px; line-height:26px"> 
 <tbody> 
 <tr> 
 <td> 数据库 </td> 
 <td> 方言（Dialect） </td> 
 </tr> 
 <tr> 
 <td> DB2 </td> 
 <td> org.hibernate.dialect.DB2Dialect </td> 
 </tr> 
 <tr> 
 <td> DB2 AS/400 </td> 
 <td> org.hibernate.dialect.DB2400Dialect </td> 
 </tr> 
 <tr> 
 <td> DB2 OS390 </td> 
 <td> org.hibernate.dialect.DB2390Dialect </td> 
 </tr> 
 <tr> 
 <td> PostgreSQL </td> 
 <td> org.hibernate.dialect.PostgreSQLDialect </td> 
 </tr> 
 <tr> 
 <td> MySQL5 </td> 
 <td> org.hibernate.dialect.MySQL5Dialect </td> 
 </tr> 
 <tr> 
 <td> MySQL5 with InnoDB </td> 
 <td> org.hibernate.dialect.MySQL5InnoDBDialect </td> 
 </tr> 
 <tr> 
 <td> <a href="http://lib.csdn.net/base/mysql" title="MySQL知识库" style="color:rgb(223,52,52); text-decoration:none; font-weight:bold" rel="nofollow">MySQL</a>&nbsp;with MyISAM </td> 
 <td> org.hibernate.dialect.MySQLMyISAMDialect </td> 
 </tr> 
 <tr> 
 <td> <a href="http://lib.csdn.net/base/oracle" title="Oracle知识库" style="color:rgb(223,52,52); text-decoration:none; font-weight:bold" rel="nofollow">Oracle</a>（any version） </td> 
 <td> org.hibernate.dialect.OracleDialect </td> 
 </tr> 
 <tr> 
 <td> Oracle 9i </td> 
 <td> org.hibernate.dialect.Oracle9iDialect </td> 
 </tr> 
 <tr> 
 <td> Oracle 10g </td> 
 <td> org.hibernate.dialect.Oracle10gDialect </td> 
 </tr> 
 <tr> 
 <td> Oracle 11g </td> 
 <td> org.hibernate.dialect.Oracle10gDialect </td> 
 </tr> 
 <tr> 
 <td> Sybase </td> 
 <td> org.hibernate.dialect.SybaseASE15Dialect </td> 
 </tr> 
 <tr> 
 <td> Sybase Anywhere </td> 
 <td> org.hibernate.dialect.SybaseAnywhereDialect </td> 
 </tr> 
 <tr> 
 <td> Microsoft SQL Server 2000 </td> 
 <td> org.hibernate.dialect.SQLServerDialect </td> 
 </tr> 
 <tr> 
 <td> Microsoft SQL Server 2005 </td> 
 <td> org.hibernate.dialect.SQLServer2005Dialect </td> 
 </tr> 
 <tr> 
 <td> Microsoft SQL Server 2008 </td> 
 <td> org.hibernate.dialect.SQLServer2008Dialect </td> 
 </tr> 
 <tr> 
 <td> SAP DB </td> 
 <td> org.hibernate.dialect.SAPDBDialect </td> 
 </tr> 
 <tr> 
 <td> Informix </td> 
 <td> org.hibernate.dialect.InformixDialect </td> 
 </tr> 
 <tr> 
 <td> HypersonicSQL </td> 
 <td> org.hibernate.dialect.HSQLDialect </td> 
 </tr> 
 <tr> 
 <td> H2 Database </td> 
 <td> org.hibernate.dialect.H2Dialect </td> 
 </tr> 
 <tr> 
 <td> Ingres </td> 
 <td> org.hibernate.dialect.IngresDialect </td> 
 </tr> 
 <tr> 
 <td> Progress </td> 
 <td> org.hibernate.dialect.ProgressDialect </td> 
 </tr> 
 <tr> 
 <td> Mckoi SQL </td> 
 <td> org.hibernate.dialect.MckoiDialect </td> 
 </tr> 
 <tr> 
 <td> Interbase </td> 
 <td> org.hibernate.dialect.InterbaseDialect </td> 
 </tr> 
 <tr> 
 <td> Pointbase </td> 
 <td> org.hibernate.dialect.PointbaseDialect </td> 
 </tr> 
 <tr> 
 <td> FrontBase </td> 
 <td> org.hibernate.dialect.FrontbaseDialect </td> 
 </tr> 
 <tr> 
 <td> Firebird </td> 
 <td> org.hibernate.dialect.FirebirdDialect </td> 
 </tr> 
 </tbody> 
</table>