Package org.hibernate.dialect

Interface Summary

Interface	Description
ColumnAliasExtractor	Strategy for extracting the unique column alias out of a ResultSetMetaData.
LobMergeStrategy	Strategy for how dialects need LOB values to be merged.
MySQLStorageEngine	This interface defines how various MySQL storage engines behave in regard to Hibernate functionality.

Class Summary

Class	Description
AbstractHANADialect	An abstract base class for SAP HANA dialects.
AbstractHANADialect.HANABlobTypeDescriptor
Cache71Dialect	Caché 2007.1 dialect.
CockroachDB192Dialect	An SQL dialect for CockroachDB 19.2 and later.
CockroachDB201Dialect	An SQL dialect for CockroachDB 20.1 and later.
CUBRIDDialect	An SQL dialect for CUBRID (8.3.x and later).
DataDirectOracle9Dialect	A Dialect for accessing Oracle through DataDirect driver
DB2390Dialect	An SQL dialect for DB2/390.
DB2390V8Dialect	An SQL dialect for DB2/390 version 8.
DB2400Dialect	An SQL dialect for DB2/400.
DB2400V7R3Dialect	An SQL dialect for i.
DB297Dialect	An SQL dialect for DB2 9.7.
DB2Dialect	An SQL dialect for DB2.
DerbyDialect	Deprecated. HHH-6073
DerbyTenFiveDialect	Hibernate Dialect for Cloudscape 10 - aka Derby.
DerbyTenSevenDialect	Dialect for Derby 10.7
DerbyTenSixDialect	Hibernate Dialect for Cloudscape 10 - aka Derby.
Dialect	Represents a dialect of SQL implemented by a particular RDBMS.
FirebirdDialect	An SQL dialect for Firebird.
FrontBaseDialect	An SQL Dialect for Frontbase.
H2Dialect	A dialect compatible with the H2 database.
HANACloudColumnStoreDialect	An SQL dialect for the SAP HANA Cloud column store.
HANAColumnStoreDialect	An SQL dialect for the SAP HANA column store.
HANARowStoreDialect	An SQL dialect for the SAP HANA row store.
HSQLDialect	An SQL dialect compatible with HSQLDB (HyperSQL).
Informix10Dialect	Since version 10.00.xC3 Informix has limit/offset support which was introduced in July 2005.
InformixDialect	Informix dialect. Seems to work with Informix Dynamic Server Version 7.31.UD3, Informix JDBC driver version 2.21JC3.
Ingres10Dialect	A SQL dialect for Ingres 10 and later versions.
Ingres9Dialect	A SQL dialect for Ingres 9.3 and later versions.
IngresDialect	An SQL dialect for Ingres 9.2.
InnoDBStorageEngine	Represents the InnoDB storage engine.
InterbaseDialect	An SQL dialect for Interbase.
JDataStoreDialect	A Dialect for JDataStore.
MariaDB102Dialect
MariaDB103Dialect	An SQL dialect for MariaDB 10.3 and later, provides sequence support, lock-timeouts, etc.
MariaDB106Dialect	An SQL dialect for MariaDB 10.6 and later, provides skip locked support.
MariaDB10Dialect
MariaDB53Dialect
MariaDBDialect
MckoiDialect	An SQL dialect compatible with McKoi SQL
MimerSQLDialect	An Hibernate 3 SQL dialect for Mimer SQL.
MyISAMStorageEngine	Represents the MyISAM storage engine.
MySQL55Dialect	An SQL dialect for MySQL 5.5.x specific features.
MySQL57Dialect
MySQL57InnoDBDialect	Deprecated. Use "hibernate.dialect.storage_engine=innodb" environment variable or JVM system property instead.
MySQL5Dialect	An SQL dialect for MySQL 5.x specific features.
MySQL5InnoDBDialect	Deprecated. Use "hibernate.dialect.storage_engine=innodb" environment variable or JVM system property instead.
MySQL8Dialect
MySQLDialect	An SQL dialect for MySQL (prior to 5.x).
MySQLInnoDBDialect	Deprecated. Use "hibernate.dialect.storage_engine=innodb" environment variable or JVM system property instead.
MySQLMyISAMDialect	Deprecated. Use "hibernate.dialect.storage_engine=myisam" environment variable or JVM system property instead.
Oracle10gDialect	A dialect specifically for use with Oracle 10g.
Oracle12cDialect	An SQL dialect for Oracle 12c.
Oracle8iDialect	A dialect for Oracle 8i.
Oracle9Dialect	Deprecated. Use either Oracle9iDialect or Oracle10gDialect instead
Oracle9iDialect	A dialect for Oracle 9i databases.
OracleDialect	Deprecated. Use Oracle8iDialect instead.
OracleTypesHelper	A Helper for dealing with the OracleTypes class
PointbaseDialect	A Dialect for Pointbase.
PostgresPlusDialect	An SQL dialect for Postgres Plus
PostgreSQL10Dialect	An SQL dialect for Postgres 10 and later.
PostgreSQL81Dialect	An SQL dialect for Postgres
PostgreSQL82Dialect	An SQL dialect for Postgres 8.2 and later, adds support for "if exists" when dropping tables
PostgreSQL91Dialect	An SQL dialect for Postgres 9.1 and later, adds support for PARTITION BY as a keyword.
PostgreSQL92Dialect	An SQL dialect for Postgres 9.2 and later, adds support for JSON data type
PostgreSQL93Dialect	An SQL Dialect for PostgreSQL 9.3 and later.
PostgreSQL94Dialect	An SQL dialect for Postgres 9.4 and later.
PostgreSQL95Dialect	An SQL dialect for Postgres 9.5 and later.
PostgreSQL9Dialect	An SQL dialect for Postgres 9 and later.
PostgreSQLDialect	Deprecated. use PostgreSQL82Dialect instead
ProgressDialect	An SQL dialect compatible with Progress 9.1C 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.
RDMSOS2200Dialect	This is the Hibernate dialect for the Unisys 2200 Relational Database (RDMS).
SAPDBDialect	An SQL dialect compatible with SAP DB.
SQLServer2005Dialect	A dialect for Microsoft SQL 2005.
SQLServer2008Dialect	A dialect for Microsoft SQL Server 2008 with JDBC Driver 3.0 and above
SQLServer2012Dialect	Microsoft SQL Server 2012 Dialect
SQLServer2016Dialect	Microsoft SQL Server 2016 Dialect
SQLServerDialect	A dialect for Microsoft SQL Server 2000
Sybase11Dialect	A SQL dialect suitable for use with Sybase 11.9.2 (specifically: avoids ANSI JOIN syntax)
SybaseAnywhereDialect	SQL Dialect for Sybase Anywhere extending Sybase (Enterprise) Dialect (Tested on ASA 8.x)
SybaseASE157Dialect	An SQL dialect targeting Sybase Adaptive Server Enterprise (ASE) 15.7 and higher.
SybaseASE15Dialect	An SQL dialect targeting Sybase Adaptive Server Enterprise (ASE) 15 and higher.
SybaseDialect	All Sybase dialects share an IN list size limit.
Teradata14Dialect	A dialect for the Teradata database
TeradataDialect	A dialect for the Teradata database created by MCR as part of the dialect certification process.
TimesTenDialect	A SQL dialect for TimesTen 5.1.
TypeNames	This class maps a type to names.

Enum Summary

Enum	Description
Database	List all supported relational database systems.
ResultColumnReferenceStrategy	Defines how we need to reference columns in the group-by, having, and order-by clauses.