List of Hibernate Dialects [Links]

🎓 Top 15 Udemy Courses (80-90% Discount): My Udemy Courses - Ramesh Fadatare — All my Udemy courses are real-time and project oriented courses.

▶️ Subscribe to My YouTube Channel (178K+ subscribers): Java Guides on YouTube

▶️ For AI, ChatGPT, Web, Tech, and Generative AI, subscribe to another channel: Ramesh Fadatare on YouTube

<< Back to Hibernate Tutorial

Hibernate SQL Dialect is telling your Hibernate application which SQL language should be used to talk with your database.

The below is a list of Hibernate supporting dialects referred from Hibernate official API Doc:

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).
HSQLDialect.ReadUncommittedLockingStrategy
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.
MySQL5InnoDBDialect
MySQLDialect An SQL dialect for MySQL (prior to 5.x).
MySQLInnoDBDialect
MySQLMyISAMDialect
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.
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).
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.
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
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.
TypeNames This class maps a type to names.

<< Back to Hibernate Tutorial

My Top and Bestseller Udemy Courses. The sale is going on with a 70 - 80% discount. The discount coupon has been added to each course below:

Spring Boot + RabbitMQ Course - The Practical Guide

Java Guides

Search This Blog