All About Java

Hibernate4 Supported SQL dialect

Hibernate 4 Supported SQL Dialect

What is Dialect?

The Dialect describes the SQL behaviour of the JDBC driver and database to which the application is connecting.

For Hibernate Training

Please visit Hibernate Online Training

In hibernate.cfg.xml configuration file, the hibernate.dialect property should be set to the correct org.hibernate.dialect.Dialect subclass for the application database. If a dialect is specified, Hibernate will use sensible defaults for some of the other properties. This means that they do not have to be specified manually.

The org.hibernate.dialect package abstracts the SQL dialect of the underlying database.

Cache71Dialect Caché 2007.1 dialect.  org.hibernate.dialect.Cache71Dialect
This class is required in order to use Hibernate with Intersystems Cache SQL.
DB2390Dialect An SQL dialect for DB2/390.  org.hibernate.dialect.DB2390Dialect
DB2400Dialect An SQL dialect for DB2/400.
 DB2Dialect  An SQL dialect for DB2.
 DerbyDialect  Hibernate Dialect for Cloudscape 10 – aka Derby.  org.hibernate.dialect.DerbyDialect
DerbyTenFiveDialect Dialect for Derby 10.5 org.hibernate.dialect.DerbyTenFiveDialect
DerbyTenSixDialect  Dialect for Derby 10.6 org.hibernate.dialect.DerbyTenSixDialect
DerbyTenSevenDialect  Dialect for Derby 10.7 org.hibernate.dialect.DerbyTenSevenDialect
About Firebird
 An SQL dialect for Firebird.
 FrontBaseDialect  An SQL Dialect for Frontbase.
 H2Dialect  A dialect compatible with the H2 database.
About Hana
An SQL dialect for HANA Column Store. org.hibernate.dialect.HANAColumnStoreDialect
HANARowStoreDialect An SQL dialect for HANA Row Store. org.hibernate.dialect.HANARowStoreDialect
 HSQLDialect  An SQL dialect compatible with HSQLDB (HyperSQL).
 InformixDialect  Informix dialect.  org.hibernate.dialect.InformixDialect
 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.  org.hibernate.dialect.IngresDialect
 InterbaseDialect  An SQL dialect for Interbase.  org.hibernate.dialect.InterbaseDialect
 JDataStoreDialect  A Dialect for JDataStore.  org.hibernate.dialect.JDataStoreDialect
 MckoiDialect  An SQL dialect compatible with McKoi SQL  org.hibernate.dialect.MckoiDialect
 MimerSQLDialect  An Hibernate 3 SQL dialect for Mimer SQL.  org.hibernate.dialect.MimerSQLDialect
 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  Deprecated. Use either Oracle9iDialect or Oracle10gDialect instead
 Oracle9iDialect  A dialect for Oracle 9i databases.
 OracleDialect  Deprecated. Use Oracle8iDialect instead.
 PointbaseDialect  A Dialect for Pointbase.  org.hibernate.dialect.PointbaseDialect
PostgreSQL81Dialect An SQL dialect for Postgres 8.1 org.hibernate.dialect.PostgreSQL81Dialect
PostgreSQL82Dialect An SQL dialect for Postgres 8.2 org.hibernate.dialect.PostgreSQL82Dialect
PostgreSQL9Dialect An SQL dialect for Postgres 9 org.hibernate.dialect.PostgreSQL9Dialect
 PostgresPlusDialect  An SQL dialect for Postgres Plus
 PostgreSQLDialect  An SQL dialect for Postgres
 ProgressDialect  An SQL dialect compatible with Progress 9.1C
 RDMSOS2200Dialect  This is the Hibernate dialect for the Unisys 2200 Relational Database (RDMS).  org.hibernate.dialect.RDMSOS2200Dialect
 SAPDBDialect  An SQL dialect compatible with SAP DB.  org.hibernate.dialect.SAPDBDialect
 SQLServer2008Dialect  A dialect for Microsoft SQL Server 2008 with JDBC Driver 3.0 and above
 SQLServerDialect  A dialect for Microsoft SQL Server 2000 and 2005  org.hibernate.dialect.SQLServerDialect
 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 targetting Sybase Adaptive Server Enterprise (ASE) 15 and higher.
 SybaseDialect  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. It is a Oracle database. org.hibernate.dialect.TimesTenDialect

Comments are currently closed.

2 thoughts on “Hibernate4 Supported SQL dialect