Database type |
Hibernate SQL dialect |
DB2 |
Org.hibernate.dialect.DB2Dialect |
DB2 as/400 |
Org.hibernate.dialect.DB2400Dialect |
DB2 OS390 |
Org.hibernate.dialect.DB2390Dialect |
PostgreSQL 8.1 |
Org.hibernate.dialect.PostgreSQL81Dialect |
PostgreSQL 8.2 and later |
Org.hibernate.dialect.PostgreSQL82Dialect |
MySQL5 |
Org.hibernate.dialect.MySQL5Dialect |
MySQL5 with InnoDB |
Org.hibernate.dialect.MySQL5InnoDBDialect |
MySQL with MyISAM |
Org.hibernate.dialect.MySQLMyISAMDialect |
Oracle (any version) |
Org.hibernate.dialect.OracleDialect |
Oracle 9i |
Org.hibernate.dialect.Oracle9iDialect |
Oracle 10g |
Org.hibernate.dialect.Oracle10gDialect |
Oracle 11g |
Org.hibernate.dialect.Oracle10gDialect |
Sybase ASE 15.5 |
Org.hibernate.dialect.SybaseASE15Dialect |
Sybase ASE 15.7 |
Org.hibernate.dialect.SybaseASE157Dialect |
Sybase Anywhere |
Org.hibernate.dialect.SybaseAnywhereDialect |
Microsoft SQL Server 2000 |
Org.hibernate.dialect.SQLServerDialect |
Microsoft SQL Server 2005 |
Org.hibernate.dialect.SQLServer2005Dialect |
Microsoft SQL Server 2008 |
Org.hibernate.dialect.SQLServer2008Dialect |
SAP DB |
Org.hibernate.dialect.SAPDBDialect |
Informix |
Org.hibernate.dialect.InformixDialect |
Hypersonicsql |
Org.hibernate.dialect.HSQLDialect |
H2 Database |
Org.hibernate.dialect.H2Dialect |
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 |
Excerpted from http://www.360sdn.com/2013/hibernate_0526/256.html
SQL dialect configuration for oracle,sqlserver,mysql database in hibernate4 (SQL dialects)