Hibernate database dialect

hibernate still uses SQL statements to perform database operations, although all relational databases point to standard SQL statements, but all databases have some extensions to standard SQL, so there are some differences in syntax details, Hibernate therefore needs to identify these differences based on the database.

For example, we have paged queries in the MySQL database, just use the Limit keyword, and standard SQL disease does not support the Limit keyword, such as Oracle, which needs to use inline views for paging. The same procedure, when we migrate between different databases, the access details of the underlying database change, and hibernate prepares for the change, and now all we need to do is tell hibernate to set the appropriate dialect, Hibernate will be able to automatically cope with the details of the underlying database access differences

The dialects corresponding to the different databases are as follows:

Rdbms Dialect
DB2 Org.hibernate.dialect.DB2Dialect
DB2 as/400 Org.hibernate.dialect.DB2400Dialect
DB2 OS390 Org.hibernate.dialect.DB2390Dialect
PostgreSQL Org.hibernate.dialect.PostgreSQLDialect
Mysql Org.hibernate.dialect.MySQLDialect
MySQL with InnoDB Org.hibernate.dialect.MySQLInnoDBDialect
MySQL with MyISAM Org.hibernate.dialect.MySQLMyISAMDialect
Oracle (any version) Org.hibernate.dialect.OracleDialect
Oracle 9i/10g Org.hibernate.dialect.Oracle9Dialect
Sybase Org.hibernate.dialect.SybaseDialect
Sybase Anywhere Org.hibernate.dialect.SybaseAnywhereDialect
Microsoft SQL Server Org.hibernate.dialect.SQLServerDialect
SAP DB Org.hibernate.dialect.SAPDBDialect
Informix Org.hibernate.dialect.InformixDialect
Hypersonicsql Org.hibernate.dialect.HSQLDialect
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

Hibernate database dialect