Harnessing Hibernate

Appendix C. Hibernate SQL Dialects

Getting Fluent in the Local SQL

Hibernate ships with detailed support for many^[9] commercial and free relational databases. While most features will work properly without doing so, it’s important to set the hibernate.dialect configuration property to the right subclass of org.hibernate.dialect.Dialect, especially if you want to use features like native or sequence primary key generation or session locking. Choosing a dialect is also a very convenient way of setting up a whole raft of Hibernate configuration parameters you’d otherwise have to deal with individually.

Database system	Appropriate hibernate.dialect setting
Caché 2007.1	org.hibernate.dialect.Cache71Dialect
DB2	org.hibernate.dialect.DB2Dialect
DB2 AS/400	org.hibernate.dialect.DB2400Dialect
DB2 OS390	org.hibernate.dialect.DB2390Dialect
Derby	org.hibernate.dialect.DerbyDialect
Firebird	org.hibernate.dialect.FirebirdDialect
FrontBase	org.hibernate.dialect.FrontbaseDialect
H2	org.hibernate.dialect.H2Dialect
HSQLDB	org.hibernate.dialect.HSQLDialect
Informix	org.hibernate.dialect.InformixDialect
Ingres	org.hibernate.dialect.IngresDialect
Interbase	org.hibernate.dialect.InterbaseDialect
JDataStore	org.hibernate.dialect.JDataStore
Mckoi SQL	org.hibernate.dialect.MckoiDialect
Mimer SQL	org.hibernate.dialect.MimerSQLDialect
Microsoft SQL Server	org.hibernate.dialect.SQLServerDialect
MySQL (versions prior to 5.x)	org.hibernate.dialect.MySQLDialect
MySQL (version 5.x and later)	org.hibernate.dialect.MySQL5Dialect ...