In the development of hibernate programs, the need for sessionfactory configuration, simply, that is, to establish a connection with the database configuration, in the Hibernate general use of XML files to configure, However, in the configuration of the file, you need to set the dialect dialect attribute value, for different databases, the value of the dialect dialect is different, then the following lists how to set the dialect value in a different database (see table below):
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 |