Hibernate 5 Dialect

In this section we will see all the dialects supported in the Hibernate 5.

Hibernate 5 Dialect

Hibernate 5 Dialect Classes

In this section we are going to tell you about all the supported dialects in Hibernate 5 framework. Hibernate 5 is ORM technology which used to write many database. Hibernate hides SQL/JDBC functionality from programmers. It helps to develop data access  code easily very easily and fast.

Hibernate also supports oracle and MySQL latest databases. To access MySQL database you can use any of the following dialects:

  • org.hibernate.dialect.MySQL5
  • org.hibernate.dialect.MySQL5InnoDB
  • org.hibernate.dialect.MySQL57InnoDB

Hibernate 5 is very flexible and supports many different databases.

Hibernate 5 also supports the Teradata database. So, many developers are using Hibernate to access the Teradata database. The dialect for Teradata is org.hibernate.dialect.Teradata.

Here is the code to use Teradata dialect in Hibernate 5 application:

<property name="dialect">org.hibernate.dialect.MySQLDialect</property>

List of Hibernate 5 Dialect

Here is the list of database Dialect in Hibernate 5:

Dialect class Details

org.hibernate.dialect.Cache71

This is dialect for Cache database and it support for the Caché database, version 2007.1

org.hibernate.dialect.CUBRID

This dialect provide for support for the CUBRID database, version 8.3. May work with later versions.

org.hibernate.dialect.DB2

You can use this dialect for accessing the DB2 database, version 8.2.

org.hibernate.dialect.DB297

Use this dialect to access DB2 database, version 9.7.

org.hibernate.dialect.DB2390

Use this dialect to access  DB2 Universal Database for OS/390, also known as DB2/390.

org.hibernate.dialect.DB2400

Use this dialect to access  DB2 Universal Database for iSeries, also known as DB2/400.

org.hibernate.dialect.DerbyTenFive

Use this dialect to access  Derby database, version 10.5

org.hibernate.dialect.DerbyTenSix

Use this dialect to access  Derby database, version 10.6

org.hibernate.dialect.DerbyTenSeven

Use this dialect to access  Derby database, version 10.7

org.hibernate.dialect.Firebird

Use this dialect to access  Firebird database

org.hibernate.dialect.FrontBase

Use this dialect to access  Frontbase database 0

org.hibernate.dialect.H2

Use this dialect to access  H2 database

org.hibernate.dialect.HANAColumnStore 1

Use this dialect to access  SAP HANA database column store. This is the recommended dialect for the SAP HANA database.

org.hibernate.dialect.HANARowStore

Use this dialect to access  SAP HANA database row store 2

org.hibernate.dialect.HSQL

Use this dialect to access  HSQL (HyperSQL) database

org.hibernate.dialect.Informix 3

Use this dialect to access  Informix database

org.hibernate.dialect.Ingres

Use this dialect to access  Ingres database, version 9.2 4

org.hibernate.dialect.Ingres9

Use this dialect to access  Ingres database, version 9.3. May work with newer versions

org.hibernate.dialect.Ingres10 5

Use this dialect to access  Ingres database, version 10. May work with newer versions

org.hibernate.dialect.Interbase

Use this dialect to access  Interbase database. 6

org.hibernate.dialect.JDataStore

Use this dialect to access  JDataStore database

org.hibernate.dialect.McKoi 7

Use this dialect to access  McKoi database

org.hibernate.dialect.Mimer

Use this dialect to access  Mimer database, version 9.2.1. May work with newer versions 8

org.hibernate.dialect.MySQL5

Use this dialect to access  MySQL database, version 5.x

org.hibernate.dialect.MySQL5InnoDB 9

Use this dialect to access  MySQL database, version 5.x

org.hibernate.dialect.MySQL57InnoDB

Use this dialect to access  MySQL database, version 5.7. 0

org.hibernate.dialect.MariaDB

Use this dialect to access  MariadB database.

org.hibernate.dialect.MariaDB53 1

Use this dialect to access  MariadB database, version 5.3 or above.

org.hibernate.dialect.Oracle8i

Use this dialect to access  Oracle database, version 8i 2

org.hibernate.dialect.Oracle9i

Use this dialect to access  Oracle database, version 9i

org.hibernate.dialect.Oracle10g 3

Use this dialect to access  Oracle database, version 10g

org.hibernate.dialect.Pointbase

Use this dialect to access  Pointbase database 4

org.hibernate.dialect.PostgresPlus

Use this dialect to access  Postgres Plus database

org.hibernate.dialect.PostgreSQL81 5

Use this dialect to access  PostgrSQL database, version 8.1

org.hibernate.dialect.PostgreSQL82

Use this dialect to access  PostgreSQL database, version 8.2 6

org.hibernate.dialect.PostgreSQL9

Use this dialect to access  PostgreSQL database, version 9.

org.hibernate.dialect.Progress 7

Use this dialect to access  Progress database, version 9.1C.

org.hibernate.dialect.SAPDB

Use this dialect to access  SAPDB/MAXDB database. 8

org.hibernate.dialect.SQLServer

Use this dialect to access  SQL Server 2000 database

org.hibernate.dialect.SQLServer2005 9

Use this dialect to access  SQL Server 2005 database

org.hibernate.dialect.SQLServer2008

Use this dialect to access  SQL Server 2008 database 0

org.hibernate.dialect.Sybase11

Use this dialect to access  Sybase database, up to version 11.9.2

org.hibernate.dialect.SybaseAnywhere 1

Use this dialect to access  Sybase Anywhere database

org.hibernate.dialect.SybaseASE15

Use this dialect to access  Sybase Adaptive Server Enterprise database, version 15 2

org.hibernate.dialect.SybaseASE157

Use this dialect to access  Sybase Adaptive Server Enterprise database, version 15.7.

org.hibernate.dialect.Teradata 3

Use this dialect to access  Teradata database

org.hibernate.dialect.TimesTen

Use this dialect to access  TimesTen database, version 5.1. 4

In this section we have seen the list of Hibernate 5 supported dialects.

Check more Hibernate 5 tutorials: