Here I am going to share all Hibernate sql dialect list, might be helping someone.

Hibernate sql Dialect (hibernate.dialect):

DB2 :

org.hibernate.dialect.DB2Dialect

DB2 AS/400 :

org.hibernate.dialect.DB2400Dialect

DB2 OS390 :

org.hibernate.dialect.DB2390Dialect

PostgreSQL :

org.hibernate.dialect.PostgreSQLDialect

MySQL5 :

org.hibernate.dialect.MySQL5Dialect

MySQL5 with InnoDB :

org.hibernate.dialect.MySQL5InnoDBDialect

MySQL with MyISAM :

org.hibernate.dialect.MySQLMyISAMDialect

Oracle (any version) :

org.hibernate.dialect.OracleDialect

Oracle 9i :

org.hibernate.dialect.Oracle9iDialect

Oracle 10g :

org.hibernate.dialect.Oracle10gDialect

Oracle 11g :

org.hibernate.dialect.Oracle11gDialect

Sybase :

org.hibernate.dialect.SybaseASE15Dialect

Sybase Anyware :

org.hibernate.dialect.SybaseAnywareDialect

Microsoft SQL Server 2000 :

org.hibernate.dialect.SQLServerDialect

Microsoft SQL Server 2005 :

org.hibernate.dialect.SQLServer2005Dialect

Microsoft SQL Server 2008 :

org.hibernate.dialect.SQLServer2008Dialect

SAP DB :

org.hibernate.dialect.SAPDBDialect

Informix :

org.hibernate.dialect.InformixDialect

HypersonicSQL :

org.hibernate.dialect.HSQLDialect

H2 Database :

org.hibernate.dialect.H2Dialect

Ingres :

org.hibernate.dialect.IngresDialect

Progress :

org.hibernate.dialect.ProgressDialect

Mckoi SQL :

org.hibernate.dialect.MckoiDialect

Interbase :

org.hibernate.dialect.InterbaseDialect

Pointbase :

org.hibernate.dialect.PointbaseDialect

FrontBase :

org.hibernate.dialect.FrontbaseDialect

Firebird :

org.hibernate.dialect.FirebirdDialect

 

Happy Learning 🙂

About the Author:

Founder of onlinetutorialspoint.com Love Java, Python, Shell and opensource frameworks. Follow him on twitter and facebook for latest updates.

Leave A Comment