This package abstracts the SQL dialect of the underlying database.

A concrete Dialect may be specifed using hibernate.dialect.


Cache71Dialect Caché 2007.1 dialect. 
DB2390Dialect An SQL dialect for DB2/390. 
DB2400Dialect An SQL dialect for DB2/400. 
DB2Dialect An SQL dialect for DB2. 
DerbyDialect Hibernate Dialect for Cloudscape 10 - aka Derby. 
Dialect Represents a dialect of SQL implemented by a particular RDBMS. 
FirebirdDialect An SQL dialect for Firebird. 
FrontBaseDialect An SQL Dialect for Frontbase. 
H2Dialect A dialect compatible with the H2 database. 
HSQLDialect An SQL dialect compatible with HSQLDB (HyperSQL). 
InformixDialect Informix dialect. 
Ingres10Dialect A SQL dialect for Ingres 10 and later versions. 
Ingres9Dialect A SQL dialect for Ingres 9.3 and later versions. 
IngresDialect An SQL dialect for Ingres 9.2. 
InterbaseDialect An SQL dialect for Interbase. 
JDataStoreDialect A Dialect for JDataStore. 
MckoiDialect An SQL dialect compatible with McKoi SQL 
MimerSQLDialect An Hibernate 3 SQL dialect for Mimer SQL. 
MySQL5Dialect An SQL dialect for MySQL 5.x specific features. 
MySQLDialect An SQL dialect for MySQL (prior to 5.x). 
Oracle10gDialect A dialect specifically for use with Oracle 10g. 
Oracle8iDialect A dialect for Oracle 8i. 
Oracle9Dialect This class is deprecated. Use either Oracle9iDialect or Oracle10gDialect instead 
Oracle9iDialect A dialect for Oracle 9i databases. 
OracleDialect This class is deprecated. Use Oracle8iDialect instead. 
PointbaseDialect A Dialect for Pointbase. 
PostgresPlusDialect An SQL dialect for Postgres Plus 
PostgreSQLDialect An SQL dialect for Postgres

For discussion of BLOB support in Postgres, as of 8.4, have a peek at

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
The WorkArounds parameter in the URL is required to avoid an error in the Progress 9.1C JDBC driver related to PreparedStatements. 
RDMSOS2200Dialect This is the Hibernate dialect for the Unisys 2200 Relational Database (RDMS). 
ResultColumnReferenceStrategy Defines how we need to reference columns in the group-by, having, and order-by clauses. 
SAPDBDialect An SQL dialect compatible with SAP DB. 
SQLServer2005Dialect A dialect for Microsoft SQL 2005. 
SQLServer2008Dialect A dialect for Microsoft SQL Server 2008 with JDBC Driver 3.0 and above 
SQLServerDialect A dialect for Microsoft SQL Server 2000 
Sybase11Dialect A SQL dialect suitable for use with Sybase 11.9.2 (specifically: avoids ANSI JOIN syntax) 
SybaseAnywhereDialect SQL Dialect for Sybase Anywhere extending Sybase (Enterprise) Dialect (Tested on ASA 8.x) 
SybaseASE15Dialect An SQL dialect targeting Sybase Adaptive Server Enterprise (ASE) 15 and higher. 
SybaseDialect This class is deprecated. use AbstractTransactSQLDialect, SybaseASE15Dialect or SQLServerDialect instead depending on need. 
TeradataDialect A dialect for the Teradata database created by MCR as part of the dialect certification process. 
TimesTenDialect A SQL dialect for TimesTen 5.1. 
TypeNames This class maps a type to names.