Hibernate SQL Dialects Collection
Published: December 28, 2009 , Updated: April 21, 2011 , Author: mkyong
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.
[...] Hibernate Dialect Collection A list of the dialect collection for different type of database vendors. [...]
[...] 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. [...]