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: