Top Description Interfaces Classes Enums
[default module]

Package org.hibernate.dialect


This package abstracts over the multifarious dialects of SQL understood by the databases supported by Hibernate. A concrete implementation of org.hibernate.dialect.Dialect defines the variant understood by a certain RDBMS.

A concrete Dialect may be explicitly selected using hibernate.dialect, but this is not usually necessary unless a program uses a custom implementation.

See Also
org.hibernate.dialect.Dialect

Interface Summary

Modifier and TypeInterface and Description
public interface
ColumnAliasExtractor

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

public interface
DatabaseVersion

Details about the underlying database, as understood by a Dialect.

public interface
DialectLogging

Logging related to Hibernate dialects

public interface
FunctionalDependencyAnalysisSupport

Dialect support information for primary key functional dependency analysis within GROUP BY and ORDER BY clauses.

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.

public abstract class
public abstract class
AbstractPostgreSQLStructJdbcType

Implementation for serializing/deserializing an embeddable aggregate to/from the PostgreSQL component format.

public abstract class
AbstractTransactSQLDialect

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

public class
BooleanDecoder

Utility for decoding boolean representations.

public class
CockroachDialect

A SQL dialect for CockroachDB 21.1 and above.

pack-priv class
public class
CockroachSqlAstTranslator<T extends JdbcOperation>

A SQL AST translator for Cockroach.

public class
DB2400Dialect

Deprecated Use DB2iDialect
An SQL dialect for DB2/400.
public class
DB2400V7R3Dialect

Deprecated Use DB2iDialect
An SQL dialect for i.
public class
DB2Dialect

A SQL dialect for DB2 for LUW (Linux, Unix, and Windows) version 10.5 and above.

public class
DB2iDialect

A SQL dialect for DB2 for IBM i version 7.1 and above, previously known as "DB2/400".

public class
DB2iSqlAstTranslator<T extends JdbcOperation>

A SQL AST translator for DB2i.

public class
DB2SqlAstTranslator<T extends JdbcOperation>

A SQL AST translator for DB2.

public class
DB2StructJdbcType

DB2 supports UDTs but not in JDBC, so there is a feature called "transforms", which allows to specify an automatic translation from one data type to another.

public class
DB2zDialect

A SQL dialect for DB2 for z/OS version 12.1 and above, previously known as:

  • "Db2 UDB for z/OS", and
  • "Db2 UDB for z/OS and OS/390".
public class
DB2zSqlAstTranslator<T extends JdbcOperation>

A SQL AST translator for DB2z.

public class
DerbyDialect

A SQL dialect for Apache Derby 10.15.2 and above.

public class
DerbySqlAstTranslator<T extends JdbcOperation>

A SQL AST translator for Derby.

public abstract class
Dialect

Represents a dialect of SQL implemented by a particular RDBMS.

public class
DialectDelegateWrapper

A wrapper of Dialect, to allow decorating some selected methods without having to extend the original class.

public class
public class
public class
public class
H2SqlAstTranslator<T extends JdbcOperation>

A SQL AST translator for H2.

public class
HANACloudColumnStoreDialect

Deprecated use HANAColumnStoreDialect(400)
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
HANASqlAstTranslator<T extends JdbcOperation>

A SQL AST translator for HANA.

public class
HSQLDialect

A SQL dialect for HSQLDB (HyperSQL) 2.6.1 and above.

public class
HSQLSqlAstTranslator<T extends JdbcOperation>

A SQL AST translator for HSQL.

public class
InnoDBStorageEngine

Represents the InnoDB storage engine.

public class
JsonHelper

A Helper for serializing and deserializing JSON, based on an org.hibernate.metamodel.mapping.EmbeddableMappingType.

public class
MariaDB106Dialect

Deprecated use MariaDBDialect(1060)
An SQL dialect for MariaDB 10.6 and later, provides skip locked support.
public class
MariaDBDialect

A SQL dialect for MariaDB 10.3 and above.

public class
MariaDBSqlAstTranslator<T extends JdbcOperation>

A SQL AST translator for MariaDB.

public class
MyISAMStorageEngine

Represents the MyISAM storage engine.

public class
MySQL8Dialect

Deprecated use MySQLDialect(800)
public class
public class
MySQLDialect

A SQL dialect for MySQL 5.7 and above.

public class
MySQLEnumJdbcType

Represents an enum type on MySQL.

public class
MySQLServerConfiguration

Utility class that extract some initial configuration from the database for MySQLDialect and related dialects.

public class
MySQLSqlAstTranslator<T extends JdbcOperation>

A SQL AST translator for MySQL.

public class
OracleArrayJdbcType

Descriptor for ARRAY handling.

public class
public class
public class
OracleDialect

A SQL dialect for Oracle 11g Release 2 and above.

public class
OracleJdbcHelper

The following class provides some convenience methods for accessing JdbcType instance, that are loaded into the app class loader, where they have access to the JDBC driver classes.

public class
OracleJsonJdbcType

Specialized type mapping for JSON and the JSON SQL data type for Oracle.

public class
OracleNestedTableJdbcType

Descriptor for ARRAY handling.

public class
public class
public class
OracleServerConfiguration

Utility class that extract some initial configuration from the database for OracleDialect.

public class
OracleSqlAstTranslator<T extends JdbcOperation>

A SQL AST translator for Oracle.

public class
public class
OracleTypes

The Oracle specific JDBC type code.

public class
public class
PgJdbcHelper

The following class provides some convenience methods for accessing JdbcType instance, that are loaded into the app class loader, where they have access to the JDBC driver classes.

public class
PostgresPlusDialect

An SQL dialect for Postgres Plus

public class
public class
public class
public class
PostgreSQLDialect

A SQL dialect for PostgreSQL 11 and above.

public class
PostgreSQLEnumJdbcType

Represents a named enum type on PostgreSQL.

public class
public class
public class
public class
public class
PostgreSQLSqlAstTranslator<T extends JdbcOperation>

A SQL AST translator for PostgreSQL.

public class
public class
public class
public class
public class
SimpleDatabaseVersion

Simple version of DatabaseVersion

public class
SpannerDialect

A SQL dialect for Cloud Spanner.

pack-priv class
SpannerDialectTableExporter

The exporter for Cloud Spanner CREATE and DROP table statements.

public class
SpannerSqlAstTranslator<T extends JdbcOperation>

A SQL AST translator for Spanner.

public abstract class
SqlAstTranslatorWithMerge<T extends JdbcOperation>

Base for translators which support a full insert-or-update-or-delete (MERGE) command.

public class
SqlAstTranslatorWithUpsert<T extends JdbcOperation>

Base SqlAstTranslator for translators which support an insert-or-update (UPSERT) command

public class
SQLServer2012Dialect

Deprecated use SQLServerDialect(11)
A dialect for Microsoft SQL Server 2012
public class
SQLServer2016Dialect

Deprecated use SQLServerDialect(13)
Microsoft SQL Server 2016 Dialect
public class
SQLServerDialect

A dialect for Microsoft SQL Server 2008 and above

public class
SQLServerSqlAstTranslator<T extends JdbcOperation>

A SQL AST translator for SQL Server.

public class
StructHelper

A Helper for serializing and deserializing struct, based on an EmbeddableMappingType.

public class
public class
SybaseASEDialect

A SQL dialect for Sybase Adaptive Server Enterprise 16 and above.

public class
SybaseASESqlAstTranslator<T extends JdbcOperation>

A SQL AST translator for Sybase ASE.

public class
SybaseDialect

Superclass for all Sybase dialects.

public class
SybaseSqlAstTranslator<T extends JdbcOperation>

A SQL AST translator for Sybase.

public class
SybaseSqmToSqlAstConverter<T extends Statement>

A SQM to SQL AST translator for Sybase ASE.

public class
public class
TiDBSqlAstTranslator<T extends JdbcOperation>

A SQL AST translator for TiDB.

public class
VarcharUUIDJdbcType

Specialized type mapping for UUID and the UUID SQL data type, which binds and reads the UUID through JDBC getString/setString methods.

public class
XmlHelper

A Helper for serializing and deserializing XML, based on an EmbeddableMappingType.

Enum Summary

Modifier and TypeEnum and Description
public enum
Database

A list of relational database systems for which Hibernate can resolve a Dialect.

public enum
DmlTargetColumnQualifierSupport

Indicates the level of qualifier support used by the dialect when referencing a column.

public enum
GroupByConstantRenderingStrategy

Strategies for rendering a constant in a group by.

public enum
GroupBySummarizationRenderingStrategy

Strategies for rendering summarization function like rollup and cube in a group by.

public enum
NationalizationSupport

Indicates if and how a database supports the use of nationalized character data (Unicode).

public enum
NullOrdering

The order of null.

public enum
public enum
ResultColumnReferenceStrategy

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

public enum
RowLockStrategy

The strategy for rendering which row to lock with the FOR UPDATE OF clause.

public enum
SelectItemReferenceStrategy

Strategies for referring to a select item.

public enum
public enum
TimeZoneSupport

Describes the extent to which a given database supports the SQL with time zone types.