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
Dialect
s in this package in order to customize certain aspects of the SQL generated by Hibernate.
Dialect
may be explicitly selected using
"hibernate.dialect", but
this is not usually necessary unless a program uses a custom
implementation.-
Interface Summary Interface Description ColumnAliasExtractor Strategy for extracting the unique column alias out of aResultSetMetaData
.DatabaseVersion Details about the underlying database, as understood by a Dialect.Dialect.SizeStrategy Pluggable strategy for determining theSize
to use for columns of a given SQL type.LobMergeStrategy Strategy for how dialects needLOB
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 AbstractPostgreSQLJsonJdbcType 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.DB2390Dialect Deprecated. UseDB2zDialect
DB2390V8Dialect Deprecated. useDB2390Dialect(8)
DB2400Dialect Deprecated. UseDB2iDialect
DB2400V7R3Dialect Deprecated. UseDB2iDialect
DB297Dialect Deprecated. useDB2Dialect(970)
DB2Dialect A SQL dialect for DB2 for LUW (Linux, Unix, and Windows) version 10.5 and above.DB2iDialect A SQL dialect for DB2 for iSeries 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.DerbyTenFiveDialect Deprecated. useDerbyDialect(1050)
DerbyTenSevenDialect Deprecated. useDerbyDialect(1070)
DerbyTenSixDialect Deprecated. useDerbyDialect(1060)
Dialect Represents a dialect of SQL implemented by a particular RDBMS.H2Dialect A SQL dialect for H2.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 anEmbeddableMappingType
.MariaDB102Dialect Deprecated. useMariaDBDialect(1020)
MariaDB103Dialect Deprecated. useMariaDBDialect(1030)
MariaDB106Dialect Deprecated. useMariaDBDialect(1060)
MariaDB10Dialect Deprecated. useMariaDBDialect(1000)
MariaDB53Dialect Deprecated. useMariaDBDialect(530)
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.MySQL55Dialect Deprecated. useMySQLDialect(550)
MySQL57Dialect Deprecated. useMySQLDialect(570)
MySQL5Dialect Deprecated. useMySQLDialect(500)
MySQL8Dialect Deprecated. useMySQLDialect(800)
MySQLDialect A SQL dialect for MySQL 5.7 and above.MySQLServerConfiguration MySQLSqlAstTranslator<T extends JdbcOperation> A SQL AST translator for MySQL.Oracle10gDialect Deprecated. useOracleDialect(10)
Oracle12cDialect Deprecated. useOracleDialect(12)
Oracle8iDialect Deprecated. useOracleDialect(8)
Oracle9iDialect Deprecated. useOracleDialect(9)
OracleArrayJdbcType Descriptor forARRAY
handling.OracleBooleanJdbcType OracleDialect A SQL dialect for Oracle 11g Release 2 and above.OracleJsonJdbcType Specialized type mapping forJSON
and the JSON SQL data type for Oracle.OracleSqlAstTranslator<T extends JdbcOperation> A SQL AST translator for Oracle.OracleStructJdbcType OracleTypes The Oracle specific JDBC type code.OracleTypesHelper A Helper for dealing with the OracleTypes classOracleXmlJdbcType PostgresPlusDialect An SQL dialect for Postgres PlusPostgreSQL10Dialect Deprecated. usePostgreSQLDialect(1000)
PostgreSQL81Dialect Deprecated. usePostgreSQLDialect(810)
PostgreSQL82Dialect Deprecated. usePostgreSQLDialect(820)
PostgreSQL91Dialect Deprecated. usePostgreSQLDialect(910)
PostgreSQL92Dialect Deprecated. usePostgreSQLDialect(920)
PostgreSQL93Dialect Deprecated. usePostgreSQLDialect(810)
PostgreSQL94Dialect Deprecated. usePostgreSQLDialect(940)
PostgreSQL95Dialect Deprecated. usePostgreSQLDialect(950)
PostgreSQL9Dialect Deprecated. usePostgreSQLDialect(900)
PostgreSQLDialect A SQL dialect for PostgreSQL 10 and above.PostgreSQLInetJdbcType PostgreSQLIntervalSecondJdbcType PostgreSQLJsonbJdbcType PostgreSQLJsonJdbcType PostgreSQLPGObjectJdbcType PostgreSQLSqlAstTranslator<T extends JdbcOperation> A SQL AST translator for PostgreSQL.PostgreSQLStructJdbcType Implementation for serializing/deserializing an embeddable aggregate to/from the PostgreSQL component format.Replacer SimpleDatabaseVersion Simple version of DatabaseVersionSpannerDialect A SQL dialect for Cloud Spanner.SpannerSqlAstTranslator<T extends JdbcOperation> A SQL AST translator for Spanner.SQLServer2005Dialect Deprecated. useSQLServerDialect(9)
SQLServer2008Dialect Deprecated. useSQLServerDialect(10)
SQLServer2012Dialect Deprecated. useSQLServerDialect(11)
SQLServer2016Dialect Deprecated. useSQLServerDialect(11)
SQLServerDialect A dialect for Microsoft SQL Server 2008 and aboveSQLServerSqlAstTranslator<T extends JdbcOperation> A SQL AST translator for SQL Server.StructHelper A Helper for serializing and deserializing struct, based on anEmbeddableMappingType
.Sybase11Dialect Deprecated. useSybaseASEDialect
insteadSybaseASE157Dialect Deprecated. useSybaseASEDialect(1570)
SybaseASE15Dialect Deprecated. useSybaseASEDialect(1500)
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.TypeNames This class maintains a mapping of JDBC type codes to SQL type names for a dialect of SQL.VarcharUUIDJdbcType Specialized type mapping forUUID
and the UUID SQL data type, which binds and reads the UUID through JDBCgetString
/setString
methods.XmlHelper A Helper for serializing and deserializing XML, based on anEmbeddableMappingType
. -
Enum Summary Enum Description Database A list of relational database systems for which Hibernate can resolve aDialect
.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.TimeZoneSupport Describes the extent to which a given database supports the SQLwith time zone
types.