Hibernate why to configure the dialect of the database

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

For example, when paging through a MySQL database, just use the Limit keyword, and standard SQL does not support the Limit keyword, such as Oracle, which needs to be paged using inline views. The same application needs to be migrated between different databases, the details of access to the underlying database will change, and Hibernate is prepared for the change, and what the developer needs to do is tell the hibernate application what kind of database to use at the bottom-this is the database dialect.