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, so there are some differences in syntax details. Therefore, hibernate needs to identify these differences based on the database.
The same application, if migrated between different databases, the details of access to the underlying database change, what developers need to do is tell the hibernate application what kind of database to use at the bottom------This is the database dialect .
Properties:
Mysql |
Org.hibernate.dialect.MySQLDialect |
MySQL with InnoDB |
Org.hibernate.dialect.MySQLInnoDBDialect |
MySQL with MyISAM |
Org.hibernate.dialect.MySQLMyISAMDialect |
MySQL 5 |
Org.hibernate.dialect.MySQL5Dialect |
MySQL 5 with InnoDB |
Org.hibernate.dialect.MySQL5InnoDBDialect |
All database dialects can be found in the%hibernate%/project/ect/hibernate.properties.
La La la
5--Basic usage of Hibernate--4 4 database dialect