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.
Refer to this Hibernate SQL dialects documentation for further information.
Hello,
as Config, the program working correctly
But, I wonder why org.hibernate.dialect.MySQL5InnoDBDialect seem like compatible with DB2
is there any dialect for sqlite
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
You should tell in your article for which version of Hibernate it applies ;
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”.
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
is there any dialect for Google big query
Great.
Thank you for this list.
That was very useful.
Thank you.
I am trying to use SQLite with hibernate. Could please provide the hibernate.dialect for SQLite?