Package org.hibernate.dialect

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

Related Packages

Package	Description
org.hibernate	This package defines the central Hibernate APIs, beginning with SessionFactory, which represents an instance of Hibernate at runtime and is the source of new instances of Session and StatelessSession, the most important APIs exposing persistence-related operations for entities.
org.hibernate.dialect.aggregate	Support for Dialect-specific aggregate column types, including user-defined composite types, and JSON or XML types.
org.hibernate.dialect.function	Contains implementations of SqmFunctionDescriptor describing a range of relatively-sophisticated SQL functions available in various dialects.
org.hibernate.dialect.hint	Support for query hints using Dialect-specific syntax.
org.hibernate.dialect.identity	Support for Dialect-specific identity column handling.
org.hibernate.dialect.lock	Support for Dialect-specific locking strategies.
org.hibernate.dialect.pagination	Support for Dialect-specific pagination strategies.
org.hibernate.dialect.sequence	Support for Dialect-specific sequence handling.
org.hibernate.dialect.temptable	Support for temporary tables.
org.hibernate.dialect.unique	Support for Dialect-specific unique constraint definition.

Class	Description
AbstractHANADialect	Deprecated, for removal: This API element is subject to removal in a future version. Will be replaced with HANADialect in the future.
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.
AzureSQLServerDialect	A SQL dialect for Azure SQL Server.
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.
ColumnAliasExtractor	Strategy for extracting the unique column alias out of a ResultSetMetaData.
Database	A list of relational database systems for which Hibernate can resolve a Dialect.
DatabaseVersion	Details about the underlying database, as understood by a Dialect.
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.
DB2GetObjectExtractor<T>	Variant of the GetObjectExtractor that catches a NullPointerException, because the DB2 JDBC driver runs into that exception when trying to access a null value with the getObject(int, Class) and getObject(String, Class) methods.
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.15.2 and above.
DerbySqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for Derby.
Dialect	Represents a dialect of SQL implemented by a particular RDBMS.
Dialect.SizeStrategy	Pluggable strategy for determining the Size to use for columns of a given SQL type.
DialectDelegateWrapper	A wrapper of Dialect, to allow decorating some selected methods without having to extend the original class.
DialectLogging	Logging related to Hibernate dialects
DmlTargetColumnQualifierSupport	Indicates the level of qualifier support used by the dialect when referencing a column.
FunctionalDependencyAnalysisSupport	Dialect support information for primary key functional dependency analysis within GROUP BY and ORDER BY clauses.
FunctionalDependencyAnalysisSupportImpl
GroupByConstantRenderingStrategy	Strategies for rendering a constant in a group by.
GroupBySummarizationRenderingStrategy	Strategies for rendering summarization function like rollup and cube in a group by.
H2Dialect	A SQL dialect for H2.
H2Dialect.OrdinalParameterMarkerStrategy
H2DurationIntervalSecondJdbcType
H2JsonJdbcType	H2 requires binding JSON via setBytes methods.
H2SqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for H2.
HANACloudColumnStoreDialect	Deprecated, for removal: This API element is subject to removal in a future version. use HANADialect with DatabaseVersion.make( 4 ) instead
HANAColumnStoreDialect	Deprecated, for removal: This API element is subject to removal in a future version. use HANADialect instead
HANADialect	An SQL dialect for the SAP HANA Platform and Cloud.
HANARowStoreDialect	Deprecated, for removal: This API element is subject to removal in a future version. use HANADialect instead
HANAServerConfiguration	Utility class that extract some initial configuration from the database for HANADialect.
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.
LobMergeStrategy	Strategy for how dialects need LOB values to be merged.
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.
MySQL8Dialect	Deprecated. use MySQLDialect(800)
MySQLCastingJsonJdbcType
MySQLDialect	A SQL dialect for MySQL 5.7 and above.
MySQLEnumJdbcType	Deprecated, for removal: This API element is subject to removal in a future version. Use EnumJdbcType instead
MySQLServerConfiguration	Utility class that extract some initial configuration from the database for MySQLDialect and related dialects.
MySQLSqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for MySQL.
MySQLStorageEngine	This interface defines how various MySQL storage engines behave in regard to Hibernate functionality.
NationalizationSupport	Indicates if and how a database supports the use of nationalized character data (Unicode).
NullOrdering	The order of null.
OracleArrayJdbcType	Descriptor for ARRAY handling.
OracleArrayJdbcTypeConstructor	Factory for OracleArrayJdbcType.
OracleBaseStructJdbcType
OracleBooleanJdbcType
OracleDialect	A SQL dialect for Oracle 11g Release 2 and above.
OracleEnumJdbcType	Represents a named enum type on Oracle 23ai+.
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.
OracleNestedTableJdbcType	Descriptor for TABLE handling.
OracleNestedTableJdbcTypeConstructor	Factory for OracleNestedTableJdbcType.
OracleOrdinalEnumJdbcType	Represents a named enum type on Oracle 23ai+.
OracleReflectionStructJdbcType
OracleServerConfiguration	Utility class that extract some initial configuration from the database for OracleDialect.
OracleSqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for Oracle.
OracleStructJdbcType
OracleTypes	The Oracle specific JDBC type code.
OracleUserDefinedTypeExporter
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
PostgreSQLArrayJdbcType	Descriptor for ARRAY handling.
PostgreSQLArrayJdbcTypeConstructor	Factory for PostgreSQLArrayJdbcType.
PostgreSQLCastingInetJdbcType
PostgreSQLCastingIntervalSecondJdbcType
PostgreSQLCastingJsonJdbcType
PostgreSQLDialect	A SQL dialect for PostgreSQL 11 and above.
PostgreSQLDriverKind
PostgreSQLEnumJdbcType	Represents a named enum type on PostgreSQL.
PostgreSQLInetJdbcType
PostgreSQLIntervalSecondJdbcType
PostgreSQLJsonPGObjectJsonbType
PostgreSQLJsonPGObjectJsonType
PostgreSQLOrdinalEnumJdbcType	Represents a named enum type on PostgreSQL.
PostgreSQLSqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for PostgreSQL.
PostgreSQLStructCastingJdbcType
PostgreSQLStructPGObjectJdbcType
PostgreSQLUUIDJdbcType
Replacer
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.
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
SQLServer2012Dialect	Deprecated. use SQLServerDialect(11)
SQLServer2016Dialect	Deprecated. use SQLServerDialect(13)
SQLServerDialect	A dialect for Microsoft SQL Server 2008 and above
SQLServerSqlAstTranslator<T extends JdbcOperation>	A SQL AST translator for SQL Server.
StructAttributeValues
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.
SybaseDriverKind
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.
TimeZoneSupport	Describes the extent to which a given database supports the SQL with time zone types.
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.