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

Jul 2, 2017 · 4 min read · Hibernate Dialects  ·
Share on:

MySQL Dialects

1org.hibernate.dialect.MySQL55Dialect

An SQL dialect for MySQL 5.5.x specific features.


1org.hibernate.dialect.MySQL57Dialect

Dialect for MySQL 5.7.x


1org.hibernate.dialect.MySQL57InnoDBDialect

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


1org.hibernate.dialect.MySQL5Dialect

An SQL dialect for MySQL 5.x specific features.


1org.hibernate.dialect.MySQL5InnoDBDialect

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


1org.hibernate.dialect.MySQLDialect

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


1org.hibernate.dialect.MySQLInnoDBDialect

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


1org.hibernate.dialect.MySQLMyISAMDialect

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


PostgreSQL Dialects

1org.hibernate.dialect.PostgresPlusDialect

An SQL dialect for Postgres Plus


1org.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.


1org.hibernate.dialect.PostgreSQL82Dialect

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


1org.hibernate.dialect.PostgreSQL91Dialect

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


1org.hibernate.dialect.PostgreSQL92Dialect

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


1org.hibernate.dialect.PostgreSQL93Dialect

An SQL Dialect for PostgreSQL 9.3 and later.


1org.hibernate.dialect.PostgreSQL94Dialect

An SQL dialect for Postgres 9.4 and later.


1org.hibernate.dialect.PostgreSQL95Dialect

An SQL dialect for Postgres 9.5 and later.


1org.hibernate.dialect.PostgreSQL9Dialect

An SQL dialect for Postgres 9 and later.


1org.hibernate.dialect.PostgreSQLDialect

Deprecated. use PostgreSQL82Dialect instead


Oracle Dialects

1org.hibernate.dialect.Oracle10gDialect

A dialect specifically for use with Oracle 10g.


1org.hibernate.dialect.Oracle12cDialect

An SQL dialect for Oracle 12c.


1org.hibernate.dialect.Oracle8iDialect

A dialect for Oracle 8i.


1org.hibernate.dialect.Oracle9Dialect

Deprecated. Use either Oracle9iDialect or Oracle10gDialect instead


1org.hibernate.dialect.Oracle9iDialect

A dialect for Oracle 9i databases.


1org.hibernate.dialect.OracleDialect

Deprecated. Use Oracle8iDialect instead.


1org.hibernate.dialect.OracleTypesHelper

A Helper for dealing with the OracleTypes class


1org.hibernate.dialect.DataDirectOracle9Dialect

A Dialect for accessing Oracle through DataDirect driver


SQL Server Dialects


1org.hibernate.dialect.SQLServer2005Dialect

A dialect for Microsoft SQL 2005.


1org.hibernate.dialect.SQLServer2008Dialect

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


1org.hibernate.dialect.SQLServer2012Dialect

Microsoft SQL Server 2012 Dialect


1org.hibernate.dialect.SQLServerDialect

A dialect for Microsoft SQL Server 2000


DB2 Dialects

1org.hibernate.dialect.DB2390Dialect

An SQL dialect for DB2/390.


1org.hibernate.dialect.DB2400Dialect

An SQL dialect for DB2/400.


1org.hibernate.dialect.DB297Dialect

An SQL dialect for DB2 9.7.


1org.hibernate.dialect.DB2Dialect

An SQL dialect for DB2.


Sybase Dialects

1org.hibernate.dialect.Sybase11Dialect

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


1org.hibernate.dialect.SybaseAnywhereDialect

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


1org.hibernate.dialect.SybaseASE157Dialect

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


1org.hibernate.dialect.SybaseASE15Dialect

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


1org.hibernate.dialect.SybaseDialect

All Sybase dialects share an IN list size limit.


Ingres Dialects

1org.hibernate.dialect.Ingres10Dialect

A SQL dialect for Ingres 10 and later versions.


1org.hibernate.dialect.Ingres9Dialect

A SQL dialect for Ingres 9.3 and later versions.


1org.hibernate.dialect.IngresDialect

An SQL dialect for Ingres 9.2.


Other Database dialects

1org.hibernate.dialect.AbstractHANADialec

An abstract base class for HANA dialects.


1org.hibernate.dialect.Cache71Dialect

Caché 2007.1 dialect.


1org.hibernate.dialect.CUBRIDDialect

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


1org.hibernate.dialect.DerbyDialect

Deprecated


1org.hibernate.dialect.DerbyTenFiveDialect

Hibernate Dialect for Cloudscape 10 - aka Derby.


1org.hibernate.dialect.DerbyTenSevenDialect

Dialect for Derby 10.7


1org.hibernate.dialect.DerbyTenSixDialect

Hibernate Dialect for Cloudscape 10 - aka Derby.


1org.hibernate.dialect.FirebirdDialect

An SQL dialect for Firebird.


1org.hibernate.dialect.FrontBaseDialect

An SQL Dialect for Frontbase.


1org.hibernate.dialect.H2Dialect

A dialect compatible with the H2 database.


1org.hibernate.dialect.HANAColumnStoreDialect

An SQL dialect for HANA.


1org.hibernate.dialect.HANARowStoreDialect

An SQL dialect for HANA.


1org.hibernate.dialect.HSQLDialect

An SQL dialect compatible with HSQLDB (HyperSQL).


1org.hibernate.dialect.Informix10Dialec

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


1org.hibernate.dialect.InformixDialect

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


1org.hibernate.dialect.InnoDBStorageEngine

Represents the InnoDB storage engine.


1org.hibernate.dialect.InterbaseDialect

An SQL dialect for Interbase.


1org.hibernate.dialect.JDataStoreDialect

A Dialect for JDataStore.


1org.hibernate.dialect.MariaDB53Dialect

MariaDB Dialect for MariaDB 5.3 and above


1org.hibernate.dialect.MariaDBDialect

MariaDB Dialect


1org.hibernate.dialect.MckoiDialect

An SQL dialect compatible with McKoi SQL


1org.hibernate.dialect.MimerSQLDialect

An Hibernate 3 SQL dialect for Mimer SQL.


1org.hibernate.dialect.MyISAMStorageEngine

Represents the MyISAM storage engine.


1org.hibernate.dialect.ProgressDialect

An SQL dialect compatible with Progress 9.1C


1org.hibernate.dialect.PointbaseDialect

A Dialect for Pointbase. Connection Parameters required:

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

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


1org.hibernate.dialect.RDMSOS2200Dialect

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


1org.hibernate.dialect.SAPDBDialect

An SQL dialect compatible with SAP DB.


1org.hibernate.dialect.Teradata14Dialect

A dialect for the Teradata database


1org.hibernate.dialect.TeradataDialect

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


1org.hibernate.dialect.TimesTenDialect

A SQL dialect for TimesTen 5.1.


comments powered by Disqus