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 the Author

author image
mkyong
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

avatar
10 Comment threads
1 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
9 Comment authors
jlgagerdeepaklilivierMariyappan VelmuruganSimon Recent comment authors
newest oldest most voted
lilivier
Guest
lilivier

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

deepak
Guest
deepak

is there any dialect for sqlite

jlgager
Guest
Mariyappan Velmurugan
Guest
Mariyappan Velmurugan

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
Guest
Simon

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
Guest
sharad

is there any dialect for Google big query

Ahmed Adel
Guest
Ahmed Adel

Great.
Thank you for this list.

kumar
Guest
kumar

That was very useful.

Thank you.

trackback
Hibernate Tutorials | J2EE Web Development Tutorials

[…] Hibernate Dialect Collection A list of the dialect collection for different type of database vendors. […]

trackback
Quick start Maven + Hibernate + MySQL Example | Hibernate

[…] Set the “show_sql” property to true will output the Hibernate SQL statement. Hibernate Dialect is telling your Hibernate application which SQL it has to generate to talk to your database. Please refer this article other database dialect – Hibernate dialect collection. […]

Auslay
Guest
Auslay

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