Main Tutorials

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.

About Author

author image
Founder of Mkyong.com, love Java and open source stuff. Follow him on Twitter. If you like my tutorials, consider make a donation to these charities.

Comments

Subscribe
Notify of
10 Comments
Most Voted
Newest Oldest
Inline Feedbacks
View all comments
kks
3 years ago

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
5 years ago

is there any dialect for sqlite

lilivier
6 years ago

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

Mariyappan Velmurugan
7 years ago

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”.

Simon
9 years ago

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

sharad
10 years ago

is there any dialect for Google big query

Ahmed Adel
11 years ago

Great.
Thank you for this list.

kumar
11 years ago

That was very useful.

Thank you.

Auslay
11 years ago

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