在开发hibernate的程序时,需要进行SessionFactory的配置,简单地说,也就是建立与数据库之间连接的配置,在hibernate中一般使用xml文件来进行配置,但是在该文件的配置中需要设置dialect方言属性值,对于不同的数据库,方言的值dialect是不同的,那么下面就列出在不同的数据库中如何设置该dialect值(参见下表):
[table]
|RDBMS|方言|
|DB2|org.hibernate.dialect.DB2Dialect|
|DB2 AS/400|org.hibernate.dialect.DB2400Dialect|
|DB2 OS390|org.hibernate.dialect.DB2390Dialect|
|PostgreSQL|org.hibernate.dialect.PostgreSQLDialect|
|MySQL|org.hibernate.dialect.MySQLDialect|
|MySQL with InnoDB|org.hibernate.dialect.MySQLInnoDBDialect|
|MySQL with MyISAM|org.hibernate.dialect.MySQLMyISAMDialect|
|Oracle (any version)|org.hibernate.dialect.OracleDialect|
|Oracle 9i/10g|org.hibernate.dialect.Oracle9Dialect|
|Sybase|org.hibernate.dialect.SybaseDialect|
|Sybase Anywhere|org.hibernate.dialect.SybaseAnywhereDialect|
|Microsoft SQL Server|org.hibernate.dialect.SQLServerDialect|
|SAP DB|org.hibernate.dialect.SAPDBDialect|
|Informix|org.hibernate.dialect.InformixDialect|
|HypersonicSQL|org.hibernate.dialect.HSQLDialect|
|Ingres|org.hibernate.dialect.IngresDialect|
|Progress|org.hibernate.dialect.ProgressDialect|
|Mckoi SQL|org.hibernate.dialect.MckoiDialect|
|Interbase|org.hibernate.dialect.InterbaseDialect|
|Pointbase|org.hibernate.dialect.PointbaseDialect|
|FrontBase|org.hibernate.dialect.FrontbaseDialect|
|Firebird|org.hibernate.dialect.FirebirdDialect|
[/table]
[table]
|RDBMS|方言|
|DB2|org.hibernate.dialect.DB2Dialect|
|DB2 AS/400|org.hibernate.dialect.DB2400Dialect|
|DB2 OS390|org.hibernate.dialect.DB2390Dialect|
|PostgreSQL|org.hibernate.dialect.PostgreSQLDialect|
|MySQL|org.hibernate.dialect.MySQLDialect|
|MySQL with InnoDB|org.hibernate.dialect.MySQLInnoDBDialect|
|MySQL with MyISAM|org.hibernate.dialect.MySQLMyISAMDialect|
|Oracle (any version)|org.hibernate.dialect.OracleDialect|
|Oracle 9i/10g|org.hibernate.dialect.Oracle9Dialect|
|Sybase|org.hibernate.dialect.SybaseDialect|
|Sybase Anywhere|org.hibernate.dialect.SybaseAnywhereDialect|
|Microsoft SQL Server|org.hibernate.dialect.SQLServerDialect|
|SAP DB|org.hibernate.dialect.SAPDBDialect|
|Informix|org.hibernate.dialect.InformixDialect|
|HypersonicSQL|org.hibernate.dialect.HSQLDialect|
|Ingres|org.hibernate.dialect.IngresDialect|
|Progress|org.hibernate.dialect.ProgressDialect|
|Mckoi SQL|org.hibernate.dialect.MckoiDialect|
|Interbase|org.hibernate.dialect.InterbaseDialect|
|Pointbase|org.hibernate.dialect.PointbaseDialect|
|FrontBase|org.hibernate.dialect.FrontbaseDialect|
|Firebird|org.hibernate.dialect.FirebirdDialect|
[/table]