在開發(fā) hibernate的程序時(shí)，需要進(jìn)行SessionFactory的配置，簡(jiǎn)單地說，也就是建立與數(shù)據(jù)庫(kù)之間連接的配置，在hibernate中一般使用xml文件來進(jìn)行配置，但是在該文件的配置中需要設(shè)置dialect方言屬性值，對(duì)于不同的數(shù)據(jù)庫(kù)，方言的值dialect是不同的，那么下面就列出在不同的數(shù)據(jù)庫(kù)中如何設(shè)置該dialect值(參見下表)：
| 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 |
Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=1794226
|
