Package org.hibernate.dialect

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

• An integrator may directly extend Dialect in order to provide support for a database unknown to Hibernate, or
• a program may extend one of the concrete Dialects in this package in order to customize certain aspects of the SQL generated by Hibernate.

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:

Dialect

Interface Summary

Interface	Description
ColumnAliasExtractor	Strategy for extracting the unique column alias out of a ResultSetMetaData.
DatabaseVersion	Details about the underlying database, as understood by a Dialect.
Dialect.SizeStrategy	Pluggable strategy for determining the Size to use for columns of a given SQL type.
DialectLogging	Logging related to Hibernate dialects
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.HANABlobType
AbstractPostgreSQLJsonPGObjectType
AbstractPostgreSQLStructJdbcType	Implementation for serializing/deserializing an embeddable aggregate to/from the PostgreSQL component format.
AbstractTransactSQLDialect	An abstract base class for Sybase and MS SQL Server dialects.
BooleanDecoder	Utility for decoding boolean representations.
CockroachDialect	A SQL dialect for CockroachDB 21.1 and above.
CockroachSqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for Cockroach.
DB2400Dialect	Deprecated. Use DB2iDialect
DB2400V7R3Dialect	Deprecated. Use DB2iDialect
DB2Dialect	A SQL dialect for DB2 for LUW (Linux, Unix, and Windows) version 10.5 and above.
DB2iDialect	A SQL dialect for DB2 for IBM i version 7.1 and above, previously known as "DB2/400".
DB2iSqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for DB2i.
DB2SqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for DB2.
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.
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".
DB2zSqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for DB2z.
DerbyDialect	A SQL dialect for Apache Derby 10.14.2 and above.
DerbySqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for Derby.
Dialect	Represents a dialect of SQL implemented by a particular RDBMS.
DialectDelegateWrapper	A wrapper of Dialect, to allow decorating some selected methods without having to extend the original class.
H2Dialect	A SQL dialect for H2.
H2Dialect.OrdinalParameterMarkerStrategy
H2DurationIntervalSecondJdbcType
H2SqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for H2.
HANACloudColumnStoreDialect	Deprecated. use HANAColumnStoreDialect(400)
HANAColumnStoreDialect	An SQL dialect for the SAP HANA column store.
HANARowStoreDialect	An SQL dialect for the SAP HANA row store.
HANASqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for HANA.
HSQLDialect	A SQL dialect for HSQLDB (HyperSQL) 2.6.1 and above.
HSQLSqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for HSQL.
InnoDBStorageEngine	Represents the InnoDB storage engine.
JsonHelper	A Helper for serializing and deserializing JSON, based on an EmbeddableMappingType.
MariaDB103Dialect	Deprecated. use MariaDBDialect(1030)
MariaDB106Dialect	Deprecated. use MariaDBDialect(1060)
MariaDBDialect	A SQL dialect for MariaDB 10.3 and above.
MariaDBSqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for MariaDB.
MyISAMStorageEngine	Represents the MyISAM storage engine.
MySQL57Dialect	Deprecated. use MySQLDialect(570)
MySQL8Dialect	Deprecated. use MySQLDialect(800)
MySQLCastingJsonJdbcType
MySQLDialect	A SQL dialect for MySQL 5.7 and above.
MySQLServerConfiguration
MySQLSqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for MySQL.
Oracle12cDialect	Deprecated. use OracleDialect(12)
OracleArrayJdbcType	Descriptor for ARRAY handling.
OracleBooleanJdbcType
OracleDialect	A SQL dialect for Oracle 11g Release 2 and above.
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.
OracleJsonJdbcType	Specialized type mapping for JSON and the JSON SQL data type for Oracle.
OracleReflectionStructJdbcType
OracleSqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for Oracle.
OracleStructJdbcType
OracleTypes	The Oracle specific JDBC type code.
OracleXmlJdbcType
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.
PostgresPlusDialect	An SQL dialect for Postgres Plus
PostgreSQL10Dialect	Deprecated. use PostgreSQLDialect(1000)
PostgreSQLCastingInetJdbcType
PostgreSQLCastingIntervalSecondJdbcType
PostgreSQLCastingJsonJdbcType
PostgreSQLDialect	A SQL dialect for PostgreSQL 10 and above.
PostgreSQLInetJdbcType
PostgreSQLIntervalSecondJdbcType
PostgreSQLJsonPGObjectJsonbType
PostgreSQLJsonPGObjectJsonType
PostgreSQLSqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for PostgreSQL.
PostgreSQLStructCastingJdbcType
PostgreSQLStructPGObjectJdbcType
Replacer
SimpleDatabaseVersion	Simple version of DatabaseVersion
SpannerDialect	A SQL dialect for Cloud Spanner.
SpannerSqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for Spanner.
SqlAstTranslatorWithMerge<T extends JdbcOperation>	Base for translators which support a full insert-or-update-or-delete (MERGE) command.
SqlAstTranslatorWithUpsert<T extends JdbcOperation>	Base SqlAstTranslator for translators which support an insert-or-update (UPSERT) command
SQLServer2008Dialect	Deprecated. use SQLServerDialect(10)
SQLServer2012Dialect	Deprecated. use SQLServerDialect(11)
SQLServer2016Dialect	Deprecated. use SQLServerDialect(11)
SQLServerDialect	A dialect for Microsoft SQL Server 2008 and above
SQLServerSqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for SQL Server.
StructHelper	A Helper for serializing and deserializing struct, based on an EmbeddableMappingType.
StructJdbcType
SybaseASEDialect	A SQL dialect for Sybase Adaptive Server Enterprise 16 and above.
SybaseASESqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for Sybase ASE.
SybaseDialect	Superclass for all Sybase dialects.
SybaseSqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for Sybase.
SybaseSqmToSqlAstConverter<T extends Statement>	A SQM to SQL AST translator for Sybase ASE.
TiDBDialect	A SQL dialect for TiDB.
TiDBSqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for TiDB.
VarcharUUIDJdbcType	Specialized type mapping for UUID and the UUID SQL data type, which binds and reads the UUID through JDBC getString/setString methods.
XmlHelper	A Helper for serializing and deserializing XML, based on an EmbeddableMappingType.

Enum Summary

Enum	Description
Database	A list of relational database systems for which Hibernate can resolve a Dialect.
DmlTargetColumnQualifierSupport	Indicates the level of qualifier support used by the dialect when referencing a column.
GroupByConstantRenderingStrategy	Strategies for rendering a constant in a group by.
GroupBySummarizationRenderingStrategy	Strategies for rendering summarization function like rollup and cube in a group by.
NationalizationSupport	Indicates if and how a database supports the use of nationalized character data (Unicode).
PostgreSQLDriverKind
ResultColumnReferenceStrategy	Defines how we need to reference columns in the group-by, having, and order-by clauses.
RowLockStrategy	The strategy for rendering which row to lock with the FOR UPDATE OF clause.
SelectItemReferenceStrategy	Strategies for referring to a select item.
SybaseDriverKind
TimeZoneSupport	Describes the extent to which a given database supports the SQL with time zone types.