Hibernate中的数据库方言（Dialect）

小咪咪 2022-05-24 14:05 250阅读 0赞

## 转自[http://blog.csdn.net/jialinqiang/article/details/8679171][http_blog.csdn.net_jialinqiang_article_details_8679171] ##

在配置hibernate.cfg.xml时需指定使用数据库的方言：

例：

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

以下是各数据库对应的方言（Dialect）：

<table> 
 <thead> 
  <tr> 
   <th>数据库</th> 
   <th>方言（Dialect)</th> 
  </tr> 
 </thead> 
 <tbody> 
  <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>MySQL with MyISAM</td> 
   <td>org.hibernate.dialect.MySQLMyISAMDialect</td> 
  </tr> 
  <tr> 
   <td>Oracle（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>

[http_blog.csdn.net_jialinqiang_article_details_8679171]: http://blog.csdn.net/jialinqiang/article/details/8679171