Top Description Interfaces Classes Enums
[default module]

Package org.hibernate.dialect


This package abstracts the SQL dialect of the underlying database.

A concrete Dialect may be specifed using hibernate.dialect.

Interface Summary

Modifier and TypeInterface and Description
public interface
ColumnAliasExtractor

Strategy for extracting the unique column alias out of a ResultSetMetaData.

public interface
LobMergeStrategy

Strategy for how dialects need LOB values to be merged.

public interface
MySQLStorageEngine

This interface defines how various MySQL storage engines behave in regard to Hibernate functionality.

Class Summary

Modifier and TypeClass and Description
public abstract class
AbstractHANADialect

An abstract base class for SAP HANA dialects.

pack-priv abstract class
AbstractTransactSQLDialect

An abstract base class for Sybase and MS SQL Server dialects.

public class
Cache71Dialect

Caché 2007.1 dialect.

public class
CockroachDB192Dialect

An SQL dialect for CockroachDB 19.2 and later.

public class
CockroachDB201Dialect

An SQL dialect for CockroachDB 20.1 and later.

public class
CUBRIDDialect

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

public class
DataDirectOracle9Dialect

Deprecated as a consequence of Oracle9Dialect being deprecated.
A Dialect for accessing Oracle through DataDirect driver
public class
DB2390Dialect

An SQL dialect for DB2/390.

public class
DB2390V8Dialect

An SQL dialect for DB2/390 version 8.

public class
DB2400Dialect

An SQL dialect for DB2/400.

public class
DB2400V7R3Dialect

An SQL dialect for i.

public class
DB297Dialect

An SQL dialect for DB2 9.7.

public class
DB2Dialect

An SQL dialect for DB2.

public class
DerbyDialect

Deprecated HHH-6073
Hibernate Dialect for Cloudscape 10 - aka Derby.
public class
DerbyTenFiveDialect

Deprecated as a consequence of DerbyDialect being deprecated.
Hibernate Dialect for Cloudscape 10 - aka Derby.
public class
DerbyTenSevenDialect

Deprecated as a consequence of DerbyTenSixDialect being deprecated.
Dialect for Derby 10.7
public class
DerbyTenSixDialect

Deprecated as a consequence of DerbyTenFiveDialect being deprecated.
Hibernate Dialect for Cloudscape 10 - aka Derby.
public abstract class
Dialect

Represents a dialect of SQL implemented by a particular RDBMS.

public class
FirebirdDialect

An SQL dialect for Firebird.

public class
FrontBaseDialect

An SQL Dialect for Frontbase.

public class
H2Dialect

A dialect compatible with the H2 database.

public class
HANACloudColumnStoreDialect

An SQL dialect for the SAP HANA Cloud column store.

public class
HANAColumnStoreDialect

An SQL dialect for the SAP HANA column store.

public class
HANARowStoreDialect

An SQL dialect for the SAP HANA row store.

public class
HSQLDialect

An SQL dialect compatible with HSQLDB (HyperSQL).

public class
Informix10Dialect

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

public class
InformixDialect

Informix dialect.

public class
Ingres10Dialect

A SQL dialect for Ingres 10 and later versions.

public class
Ingres9Dialect

A SQL dialect for Ingres 9.3 and later versions.

public class
IngresDialect

An SQL dialect for Ingres 9.2.

public class
InnoDBStorageEngine

Represents the InnoDB storage engine.

public class
InterbaseDialect

An SQL dialect for Interbase.

public class
JDataStoreDialect

A Dialect for JDataStore.

public class
public class
MariaDB103Dialect

An SQL dialect for MariaDB 10.3 and later, provides sequence support, lock-timeouts, etc.

public class
MariaDB106Dialect

An SQL dialect for MariaDB 10.6 and later, provides skip locked support.

public class
public class
public class
public class
MckoiDialect

An SQL dialect compatible with McKoi SQL

public class
MimerSQLDialect

An Hibernate 3 SQL dialect for Mimer SQL.

public class
MyISAMStorageEngine

Represents the MyISAM storage engine.

public class
MySQL55Dialect

An SQL dialect for MySQL 5.5.x specific features.

public class
public class
MySQL57InnoDBDialect

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

An SQL dialect for MySQL 5.x specific features.

public class
MySQL5InnoDBDialect

Deprecated Use "hibernate.dialect.storage_engine=innodb" environment variable or JVM system property instead.
A Dialect for MySQL 5 using InnoDB engine
public class
public class
MySQLDialect

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

public class
MySQLInnoDBDialect

Deprecated Use "hibernate.dialect.storage_engine=innodb" environment variable or JVM system property instead.
A Dialect for MySQL using InnoDB engine
public class
MySQLMyISAMDialect

Deprecated Use "hibernate.dialect.storage_engine=myisam" environment variable or JVM system property instead.
A Dialect for MySQL using the MyISAM engine
public class
Oracle10gDialect

A dialect specifically for use with Oracle 10g.

public class
Oracle12cDialect

An SQL dialect for Oracle 12c.

public class
Oracle8iDialect

A dialect for Oracle 8i.

public class
Oracle9Dialect

Deprecated Use either Oracle9iDialect or Oracle10gDialect instead
An SQL dialect for Oracle 9 (uses ANSI-style syntax where possible).
public class
Oracle9iDialect

A dialect for Oracle 9i databases.

public class
OracleDialect

Deprecated Use Oracle8iDialect instead.
An SQL dialect for Oracle, compatible with Oracle 8.
public class
OracleTypesHelper

A Helper for dealing with the OracleTypes class

public class
PointbaseDialect

A Dialect for Pointbase.

public class
PostgresPlusDialect

Deprecated as a consequence of PostgreSQLDialect being deprecated.
An SQL dialect for Postgres Plus
public class
PostgreSQL10Dialect

An SQL dialect for Postgres 10 and later.

public class
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.

public class
PostgreSQL82Dialect

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

public class
PostgreSQL91Dialect

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

public class
PostgreSQL92Dialect

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

public class
PostgreSQL93Dialect

An SQL Dialect for PostgreSQL 9.3 and later.

public class
PostgreSQL94Dialect

An SQL dialect for Postgres 9.4 and later.

public class
PostgreSQL95Dialect

An SQL dialect for Postgres 9.5 and later.

public class
PostgreSQL9Dialect

An SQL dialect for Postgres 9 and later.

public class
PostgreSQLDialect

Deprecated use PostgreSQL82Dialect instead
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.

public class
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
public class
RDMSOS2200Dialect

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

public class
SAPDBDialect

An SQL dialect compatible with SAP DB.

public class
SQLServer2005Dialect

A dialect for Microsoft SQL 2005.

public class
SQLServer2008Dialect

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

public class
SQLServer2012Dialect

Microsoft SQL Server 2012 Dialect

public class
SQLServer2016Dialect

Microsoft SQL Server 2016 Dialect

public class
SQLServerDialect

A dialect for Microsoft SQL Server 2000

public class
Sybase11Dialect

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

public class
SybaseAnywhereDialect

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

public class
SybaseASE157Dialect

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

public class
SybaseASE15Dialect

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

public class
SybaseDialect

All Sybase dialects share an IN list size limit.

public class
Teradata14Dialect

A dialect for the Teradata database

public class
TeradataDialect

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

public class
TimesTenDialect

A SQL dialect for TimesTen 5.1.

public class
TypeNames

This class maps a type to names.

Enum Summary

Modifier and TypeEnum and Description
public enum
Database

List all supported relational database systems.

public enum
ResultColumnReferenceStrategy

Defines how we need to reference columns in the group-by, having, and order-by clauses.