SQL Dialects in Hibernate

The dialect indicates the kind of database utilized in hibernate so that hibernate create proper sort of SQL articulations. For associating any hibernate application with the database, it is required to give the arrangement of SQL dialect.

Syntax of SQL Dialect

  1. <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>  

List of SQL Dialects

There are numerous Dialects classes defined for RDBMS in the org.hibernate.dialect bundle. They are as per the following:

RDBMSDialect
Oracle (any version)org.hibernate.dialect.OracleDialect
Oracle9iorg.hibernate.dialect.Oracle9iDialect
Oracle10gorg.hibernate.dialect.Oracle10gDialect
MySQLorg.hibernate.dialect.MySQLDialect
MySQL with InnoDBorg.hibernate.dialect.MySQLInnoDBDialect
MySQL with MyISAMorg.hibernate.dialect.MySQLMyISAMDialect
DB2org.hibernate.dialect.DB2Dialect
DB2 AS/400org.hibernate.dialect.DB2400Dialect
DB2 OS390org.hibernate.dialect.DB2390Dialect
Microsoft SQL Serverorg.hibernate.dialect.SQLServerDialect
Sybaseorg.hibernate.dialect.SybaseDialect
Sybase Anywhereorg.hibernate.dialect.SybaseAnywhereDialect
PostgreSQLorg.hibernate.dialect.PostgreSQLDialect
SAP DBorg.hibernate.dialect.SAPDBDialect
Informixorg.hibernate.dialect.InformixDialect
HypersonicSQLorg.hibernate.dialect.HSQLDialect
Ingresorg.hibernate.dialect.IngresDialect
Progressorg.hibernate.dialect.ProgressDialect
Mckoi SQLorg.hibernate.dialect.MckoiDialect
Interbaseorg.hibernate.dialect.InterbaseDialect
Pointbaseorg.hibernate.dialect.PointbaseDialect
FrontBaseorg.hibernate.dialect.FrontbaseDialect
Firebirdorg.hibernate.dialect.FirebirdDialect





javacodegeeks is optimized for learning.© javacodegeeks .
All Right Reserved and you agree to have read and accepted our term and condition