hibernate 连接数据库方言

3.4.1.?SQL 方言

表?3.8.?Hibernate SQL 方言（hibernate.dialect）

?

?

RDBMS??????????? DialectDB2org.hibernate.dialect.DB2DialectDB2 AS/400org.hibernate.dialect.DB2400DialectDB2 OS390org.hibernate.dialect.DB2390DialectPostgreSQLorg.hibernate.dialect.PostgreSQLDialectMySQL5org.hibernate.dialect.MySQL5DialectMySQL5 with InnoDBorg.hibernate.dialect.MySQL5InnoDBDialectMySQL with MyISAMorg.hibernate.dialect.MySQLMyISAMDialectOracle（any version）org.hibernate.dialect.OracleDialectOracle 9iorg.hibernate.dialect.Oracle9iDialectOracle 10gorg.hibernate.dialect.Oracle10gDialectOracle 11gorg.hibernate.dialect.Oracle10gDialectSybaseorg.hibernate.dialect.SybaseASE15DialectSybase Anywhereorg.hibernate.dialect.SybaseAnywhereDialectMicrosoft SQL Server 2000org.hibernate.dialect.SQLServerDialectMicrosoft SQL Server 2005org.hibernate.dialect.SQLServer2005DialectMicrosoft SQL Server 2008org.hibernate.dialect.SQLServer2008DialectSAP DBorg.hibernate.dialect.SAPDBDialectInformixorg.hibernate.dialect.InformixDialectHypersonicSQLorg.hibernate.dialect.HSQLDialectH2 Databaseorg.hibernate.dialect.H2DialectIngresorg.hibernate.dialect.IngresDialectProgressorg.hibernate.dialect.ProgressDialectMckoi SQLorg.hibernate.dialect.MckoiDialectInterbaseorg.hibernate.dialect.InterbaseDialectPointbaseorg.hibernate.dialect.PointbaseDialectFrontBaseorg.hibernate.dialect.FrontbaseDialectFirebirdorg.hibernate.dialect.FirebirdDialect

你应当总是为你的数据库将 hibernate.dialect 属性设置成正确的 org.hibernate.dialect.Dialect 子类。如果你指定一种方言，Hibernate 将为上面列出的一些属性使用合理的默认值，这样你就不用手工指定它们。

?

?文档路径：

http://docs.jboss.org/hibernate/core/3.6/reference/zh-CN/html/session-configuration.html#configuration-optional-dialects