Hibernate 5 Dialect

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

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

org.hibernate.dialect.H2

Use this dialect to access  H2 database

org.hibernate.dialect.HANAColumnStore

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

org.hibernate.dialect.HSQL

Use this dialect to access  HSQL (HyperSQL) database

org.hibernate.dialect.Informix

Use this dialect to access  Informix database

org.hibernate.dialect.Ingres

Use this dialect to access  Ingres database, version 9.2

org.hibernate.dialect.Ingres9

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

org.hibernate.dialect.Ingres10

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.

org.hibernate.dialect.JDataStore

Use this dialect to access  JDataStore database

org.hibernate.dialect.McKoi

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

org.hibernate.dialect.MySQL5

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

org.hibernate.dialect.MySQL5InnoDB

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

org.hibernate.dialect.MySQL57InnoDB

Use this dialect to access  MySQL database, version 5.7.

org.hibernate.dialect.MariaDB

Use this dialect to access  MariadB database.

org.hibernate.dialect.MariaDB53

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

org.hibernate.dialect.Oracle9i

Use this dialect to access  Oracle database, version 9i

org.hibernate.dialect.Oracle10g

Use this dialect to access  Oracle database, version 10g

org.hibernate.dialect.Pointbase

Use this dialect to access  Pointbase database

org.hibernate.dialect.PostgresPlus

Use this dialect to access  Postgres Plus database

org.hibernate.dialect.PostgreSQL81

Use this dialect to access  PostgrSQL database, version 8.1

org.hibernate.dialect.PostgreSQL82

Use this dialect to access  PostgreSQL database, version 8.2

org.hibernate.dialect.PostgreSQL9

Use this dialect to access  PostgreSQL database, version 9.

org.hibernate.dialect.Progress

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

org.hibernate.dialect.SAPDB

Use this dialect to access  SAPDB/MAXDB database.

org.hibernate.dialect.SQLServer

Use this dialect to access  SQL Server 2000 database

org.hibernate.dialect.SQLServer2005

Use this dialect to access  SQL Server 2005 database

org.hibernate.dialect.SQLServer2008

Use this dialect to access  SQL Server 2008 database

org.hibernate.dialect.Sybase11

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

org.hibernate.dialect.SybaseAnywhere

Use this dialect to access  Sybase Anywhere database

org.hibernate.dialect.SybaseASE15

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

org.hibernate.dialect.SybaseASE157

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

org.hibernate.dialect.Teradata

Use this dialect to access  Teradata database

org.hibernate.dialect.TimesTen

Use this dialect to access  TimesTen database, version 5.1.

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

Check more Hibernate 5 tutorials:

Advertisements

Ads

 

We have 1000s of tutorials on our website. Search Tutorials tutorials on our website.

Share on Google+Share on Google+

Hibernate 5 Dialect

Posted on: October 26, 2017 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

 

Discuss: Hibernate 5 Dialect  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0

Ads

 

Ads