Hibernate Database Dialects for MySQL, PostgreSQL, Oracle, SQL Server, DB2, Sybase, Ingres, H2 and other databases

MySQL Dialects

org.hibernate.dialect.MySQL55Dialect

An SQL dialect for MySQL 5.5.x specific features.


org.hibernate.dialect.MySQL57Dialect

Dialect for MySQL 5.7.x


org.hibernate.dialect.MySQL57InnoDBDialect

Deprecated. Use “hibernate.dialect.storage_engine=innodb” environment variable or JVM system property instead.


org.hibernate.dialect.MySQL5Dialect

An SQL dialect for MySQL 5.x specific features.


org.hibernate.dialect.MySQL5InnoDBDialect

Deprecated. Use “hibernate.dialect.storage_engine=innodb” environment variable or JVM system property instead.


org.hibernate.dialect.MySQLDialect

An SQL dialect for MySQL (prior to 5.x).


org.hibernate.dialect.MySQLInnoDBDialect

Deprecated. Use “hibernate.dialect.storage_engine=innodb” environment variable or JVM system property instead.


org.hibernate.dialect.MySQLMyISAMDialect

Deprecated. Use “hibernate.dialect.storage_engine=myisam” environment variable or JVM system property instead.


PostgreSQL Dialects

org.hibernate.dialect.PostgresPlusDialect

An SQL dialect for Postgres Plus


org.hibernate.dialect.PostgreSQL81Dialect

An SQL dialect for Postgres For discussion of BLOB support in Postgres, as of 8.4, have a peek at http://jdbc.postgresql.org/documentation/84/binary-data.html.


org.hibernate.dialect.PostgreSQL82Dialect

An SQL dialect for Postgres 8.2 and later, adds support for “if exists” when dropping tables


org.hibernate.dialect.PostgreSQL91Dialect

An SQL dialect for Postgres 9.1 and later, adds support for PARTITION BY as a keyword.


org.hibernate.dialect.PostgreSQL92Dialect

An SQL dialect for Postgres 9.2 and later, adds support for JSON data type


org.hibernate.dialect.PostgreSQL93Dialect

An SQL Dialect for PostgreSQL 9.3 and later.


org.hibernate.dialect.PostgreSQL94Dialect

An SQL dialect for Postgres 9.4 and later.


org.hibernate.dialect.PostgreSQL95Dialect

An SQL dialect for Postgres 9.5 and later.


org.hibernate.dialect.PostgreSQL9Dialect

An SQL dialect for Postgres 9 and later.


org.hibernate.dialect.PostgreSQLDialect

Deprecated. use PostgreSQL82Dialect instead


Oracle Dialects

org.hibernate.dialect.Oracle10gDialect

A dialect specifically for use with Oracle 10g.


org.hibernate.dialect.Oracle12cDialect

An SQL dialect for Oracle 12c.


org.hibernate.dialect.Oracle8iDialect

A dialect for Oracle 8i.


org.hibernate.dialect.Oracle9Dialect

Deprecated. Use either Oracle9iDialect or Oracle10gDialect instead


org.hibernate.dialect.Oracle9iDialect

A dialect for Oracle 9i databases.


org.hibernate.dialect.OracleDialect

Deprecated. Use Oracle8iDialect instead.


org.hibernate.dialect.OracleTypesHelper

A Helper for dealing with the OracleTypes class


org.hibernate.dialect.DataDirectOracle9Dialect

A Dialect for accessing Oracle through DataDirect driver


SQL Server Dialects


org.hibernate.dialect.SQLServer2005Dialect

A dialect for Microsoft SQL 2005.


org.hibernate.dialect.SQLServer2008Dialect

A dialect for Microsoft SQL Server 2008 with JDBC Driver 3.0 and above


org.hibernate.dialect.SQLServer2012Dialect

Microsoft SQL Server 2012 Dialect


org.hibernate.dialect.SQLServerDialect

A dialect for Microsoft SQL Server 2000


DB2 Dialects

org.hibernate.dialect.DB2390Dialect

An SQL dialect for DB2/390.


org.hibernate.dialect.DB2400Dialect

An SQL dialect for DB2/400.


org.hibernate.dialect.DB297Dialect

An SQL dialect for DB2 9.7.


org.hibernate.dialect.DB2Dialect

An SQL dialect for DB2.


Sybase Dialects

org.hibernate.dialect.Sybase11Dialect

A SQL dialect suitable for use with Sybase 11.9.2 (specifically: avoids ANSI JOIN syntax)


org.hibernate.dialect.SybaseAnywhereDialect

SQL Dialect for Sybase Anywhere extending Sybase (Enterprise) Dialect (Tested on ASA 8.x)


org.hibernate.dialect.SybaseASE157Dialect

An SQL dialect targeting Sybase Adaptive Server Enterprise (ASE) 15.7 and higher.


org.hibernate.dialect.SybaseASE15Dialect

An SQL dialect targeting Sybase Adaptive Server Enterprise (ASE) 15 and higher.


org.hibernate.dialect.SybaseDialect

All Sybase dialects share an IN list size limit.


Ingres Dialects

org.hibernate.dialect.Ingres10Dialect

A SQL dialect for Ingres 10 and later versions.


org.hibernate.dialect.Ingres9Dialect

A SQL dialect for Ingres 9.3 and later versions.


org.hibernate.dialect.IngresDialect

An SQL dialect for Ingres 9.2.


Other Database dialects

org.hibernate.dialect.AbstractHANADialec

An abstract base class for HANA dialects.


org.hibernate.dialect.Cache71Dialect

Caché 2007.1 dialect.


org.hibernate.dialect.CUBRIDDialect

An SQL dialect for CUBRID (8.3.x and later).


org.hibernate.dialect.DerbyDialect

Deprecated


org.hibernate.dialect.DerbyTenFiveDialect

Hibernate Dialect for Cloudscape 10 - aka Derby.


org.hibernate.dialect.DerbyTenSevenDialect

Dialect for Derby 10.7


org.hibernate.dialect.DerbyTenSixDialect

Hibernate Dialect for Cloudscape 10 - aka Derby.


org.hibernate.dialect.FirebirdDialect

An SQL dialect for Firebird.


org.hibernate.dialect.FrontBaseDialect

An SQL Dialect for Frontbase.


org.hibernate.dialect.H2Dialect

A dialect compatible with the H2 database.


org.hibernate.dialect.HANAColumnStoreDialect

An SQL dialect for HANA.


org.hibernate.dialect.HANARowStoreDialect

An SQL dialect for HANA.


org.hibernate.dialect.HSQLDialect

An SQL dialect compatible with HSQLDB (HyperSQL).


org.hibernate.dialect.Informix10Dialec

Since version 10.00.xC3 Informix has limit/offset support which was introduced in July 2005.


org.hibernate.dialect.InformixDialect

Informix dialect. Seems to work with Informix Dynamic Server Version 7.31.UD3, Informix JDBC driver version 2.21JC3.


org.hibernate.dialect.InnoDBStorageEngine

Represents the InnoDB storage engine.


org.hibernate.dialect.InterbaseDialect

An SQL dialect for Interbase.


org.hibernate.dialect.JDataStoreDialect

A Dialect for JDataStore.


org.hibernate.dialect.MariaDB53Dialect

MariaDB Dialect for MariaDB 5.3 and above


org.hibernate.dialect.MariaDBDialect

MariaDB Dialect


org.hibernate.dialect.MckoiDialect

An SQL dialect compatible with McKoi SQL


org.hibernate.dialect.MimerSQLDialect

An Hibernate 3 SQL dialect for Mimer SQL.


org.hibernate.dialect.MyISAMStorageEngine

Represents the MyISAM storage engine.


org.hibernate.dialect.ProgressDialect

An SQL dialect compatible with Progress 9.1C


org.hibernate.dialect.PointbaseDialect

A Dialect for Pointbase. Connection Parameters required:

hibernate.dialect org.hibernate.sql.ProgressDialect
hibernate.driver com.progress.sql.jdbc.JdbcProgressDriver
hibernate.url jdbc:JdbcProgress:T:host:port:dbname;WorkArounds=536870912
hibernate.username username
hibernate.password password

The WorkArounds parameter in the URL is required to avoid an error in the Progress 9.1C JDBC driver related to PreparedStatements.


org.hibernate.dialect.RDMSOS2200Dialect

This is the Hibernate dialect for the Unisys 2200 Relational Database (RDMS).


org.hibernate.dialect.SAPDBDialect

An SQL dialect compatible with SAP DB.


org.hibernate.dialect.Teradata14Dialect

A dialect for the Teradata database


org.hibernate.dialect.TeradataDialect

A dialect for the Teradata database created by MCR as part of the dialect certification process.


org.hibernate.dialect.TimesTenDialect

A SQL dialect for TimesTen 5.1.


Hansaraj avatar
About Hansaraj
Hansaraj is a Software Engineer experienced in Java, Groovy, JavaScript, SQL, C#, C++
comments powered by Disqus