For the database property hibernate. the correct Org. hibernate. dialect. dialect subclass. if you specify a dialect, Hibernate uses reasonable default values for some of the attributes listed above, saving you the effort to manually specify them.
Table 4.8. hibernate SQL dialect (hibernate. dialect)
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 |
SS |
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 |