hibernate December 28, 2009 by mkyong 10 comments

Hibernate SQL Dialects Collection

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

1. DB2


org.hibernate.dialect.DB2Dialect

2. DB2 AS/400


org.hibernate.dialect.DB2400Dialect

3. DB2 OS390


org.hibernate.dialect.DB2390Dialect

4. PostgreSQL


org.hibernate.dialect.PostgreSQLDialect

5. MySQL


org.hibernate.dialect.MySQLDialect

6. MySQL with InnoDB


org.hibernate.dialect.MySQLInnoDBDialect

7. MySQL with MyISAM


org.hibernate.dialect.MySQLMyISAMDialect

8. Oracle 8


org.hibernate.dialect.OracleDialect

9. Oracle 9i/10g


org.hibernate.dialect.Oracle9Dialect

10. Sybase


org.hibernate.dialect.SybaseDialect

11. Sybase Anywhere


org.hibernate.dialect.SybaseAnywhereDialect

12. Microsoft SQL Server


org.hibernate.dialect.SQLServerDialect

13. SAP DB


org.hibernate.dialect.SAPDBDialect

14. Informix


org.hibernate.dialect.InformixDialect

15. HypersonicSQL


org.hibernate.dialect.HSQLDialect

16. Ingres


org.hibernate.dialect.IngresDialect

17. Progress


org.hibernate.dialect.ProgressDialect

18. Mckoi SQL


org.hibernate.dialect.MckoiDialect

19. Interbase


org.hibernate.dialect.InterbaseDialect

20. Pointbase


org.hibernate.dialect.PointbaseDialect

21. FrontBase


org.hibernate.dialect.FrontbaseDialect

22. Firebird


org.hibernate.dialect.FirebirdDialect

Note
Refer to this Hibernate SQL dialects documentation for further information.

Written by mkyong

Founder of Mkyong.com, passionate Java and open-source technologies. If you enjoy my tutorials, consider making a donation to these charities.

All posts by mkyong Website

10 comments on “Hibernate SQL Dialects Collection”

kks

November 17, 2020 at 12:04 am

Hello,

datasource:
  hikari:
   connection-timeout: 60000
   maximum-pool-size: 300
  jdbcUrl: jdbc:db2://xxxxx
  username: xxxxx
  password: xxxxx
 jpa:
  database-platform: org.hibernate.dialect.MySQL5InnoDBDialect

as Config, the program working correctly
But, I wonder why org.hibernate.dialect.MySQL5InnoDBDialect seem like compatible with DB2

deepak
September 24, 2018 at 5:09 pm

is there any dialect for sqlite

Reply
1. jlgager
  October 25, 2018 at 12:13 pm
  
  com.github.gwenn/sqlite-dialect/0.1.0
  
  https://github.com/gwenn/sqlite-dialect
  https://search.maven.org/search?q=g:%22com.github.gwenn%22%20AND%20a:%22sqlite-dialect%22
  
  Reply
lilivier
November 3, 2017 at 9:58 pm

You should tell in your article for which version of Hibernate it applies ;

Reply
Mariyappan Velmurugan
July 14, 2016 at 1:50 pm

Hi mkyong, what does it mean by “org.hibernate.dialect.CustomSQLServerDialect”. What is the use of it? I try to use ID Generator type “SEQUENCE”, i got an exception like this “Caused by: org.hibernate.MappingException: org.hibernate.dialect.CustomSQLServerDialect does not support sequences”.

Reply
Simon
August 5, 2014 at 4:51 pm

For MySQL 5.x versions there is preferrably:

org.hibernate.dialect.MySQL5Dialect

and
org.hibernate.dialect.MySQL5InnoDBDialect

In the end the truth of this list is to be found in the hibernate docu (check for the latest version), e.g.
https://docs.jboss.org/hibernate/core/3.6/javadocs/org/hibernate/dialect/Dialect.html

Reply
sharad
December 3, 2013 at 11:50 pm

is there any dialect for Google big query

Reply
Ahmed Adel
March 17, 2013 at 1:47 am

Great.
Thank you for this list.

Reply
kumar
October 17, 2012 at 2:29 pm

That was very useful.

Thank you.

Reply
Auslay
October 10, 2012 at 8:13 pm

I am trying to use SQLite with hibernate. Could please provide the hibernate.dialect for SQLite?

Reply