View RSS Feed

My Java Tips

Hibernate Dialects

Rate this Entry
by , 05-25-2011 at 10:46 AM (3396 Views)
To set SQL dialect, one has to set the hibernate.dialect property to correct org.hibernate.dialect.Dialect subclass for the database.

Specify a dialect and then Hibernate will use defaults for some of the properties and this will save the effort of specifying them manually.

Following dialects are supported.

  • 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
  • [B]Sybase/B] 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

Submit "Hibernate Dialects" to Facebook Submit "Hibernate Dialects" to Digg Submit "Hibernate Dialects" to Submit "Hibernate Dialects" to StumbleUpon Submit "Hibernate Dialects" to Google