Hibernate is the most popular ORM. While configuring Hibernate, there is a property "hibernate.dialect" that required. This package abstracts the SQL dialect of the underlying database. You can read more about Hibernate dialect at www.hibernate.org

* DB2 – org.hibernate.dialect.DB2Dialect

* HypersonicSQL – org.hibernate.dialect.HSQLDialect

* Informix – org.hibernate.dialect.InformixDialect

* Ingres – org.hibernate.dialect.IngresDialect

* Interbase – org.hibernate.dialect.InterbaseDialect

* Pointbase – org.hibernate.dialect.PointbaseDialect

* PostgreSQL – org.hibernate.dialect.PostgreSQLDialect

* Mckoi SQL – org.hibernate.dialect.MckoiDialect

* Microsoft SQL Server – org.hibernate.dialect.SQLServerDialect

* MySQL – org.hibernate.dialect.MySQLDialect

* Oracle (any version) – org.hibernate.dialect.OracleDialect

* Oracle 9 – org.hibernate.dialect.Oracle9Dialect

* Progress – org.hibernate.dialect.ProgressDialect

* FrontBase – org.hibernate.dialect.FrontbaseDialect

* SAP DB – org.hibernate.dialect.SAPDBDialect

* Sybase – org.hibernate.dialect.SybaseDialect

* Sybase Anywhere – org.hibernate.dialect.SybaseAnywhereDialect