Hibernate SQL Dialects Collection

by

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.

mkyong

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

10 Comments
Most Voted
Newest Oldest
Inline Feedbacks
View all comments
kks
5 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

0
Reply
deepak
7 years ago

is there any dialect for sqlite

0
Reply
lilivier
8 years ago

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

0
Reply
Mariyappan Velmurugan
9 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”.

0
Reply
Simon
11 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

0
Reply
sharad
12 years ago

is there any dialect for Google big query

0
Reply
Ahmed Adel
13 years ago

Great.
Thank you for this list.

0
Reply
kumar
13 years ago

That was very useful.

Thank you.

0
Reply
Auslay
13 years ago

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

-1
Reply