Home / Hibernate / Dialects in Hibernate Framework

Dialects in Hibernate Framework

-
Dialect in Hibernate:-
  • In Hibernate Dialect is a Database specific class, It's create queries based on the configuration Dialect. for example HibernateDialect and OracleDialect.
  • It is a simple java class, which contains mapping between Java language data types and Data Base data types.
  • This class contains queries format for predefined Hibernate methods.
  • Hibernate generates queries for the specific database based on the Dialect class. If you want to shift from one data base to another just change the Dialect class name and connection Details in hibernate.cfg.xml file
  • All Dialect classes must extend Dialect(Abstract class)
  • Hibernate supports almost 30 dialect classes.
  • All the Dialect classes are present in org.hibernate.dialect package
  • We can write our own Dialect by extending Dialect class.
  • Dialect class is used to convert HQL queries into Database specific queries.
The following table showing the Supported database dialects in Hibernate
DatabaseDialect
DB2org.hibernate.dialect.DB2Dialect
DB2 AS/400org.hibernate.dialect.DB2400Dialect
DB2 OS390org.hibernate.dialect.DB2390Dialect
Firebirdorg.hibernate.dialect.FirebirdDialect
FrontBaseorg.hibernate.dialect.FrontbaseDialect
HypersonicSQLorg.hibernate.dialect.HSQLDialect
Informixorg.hibernate.dialect.InformixDialect
Interbaseorg.hibernate.dialect.InterbaseDialect
Ingresorg.hibernate.dialect.IngresDialect
Microsoft SQL Server 2005org.hibernate.dialect.SQLServer2005Dialect
Microsoft SQL Server 2008org.hibernate.dialect.SQLServer2008Dialect
Mckoi SQLorg.hibernate.dialect.MckoiDialect
MySQLorg.hibernate.dialect.MySQLDialect
MySQL with InnoDBorg.hibernate.dialect.MySQL5InnoDBDialect
MySQL with MyISAM org.hibernate.dialect.MySQLMyISAMDialect
Oracle 8iorg.hibernate.dialect.Oracle8iDialect
Oracle 9iorg.hibernate.dialect.Oracle9iDialect
Oracle 10gorg.hibernate.dialect.Oracle10gDialect
Pointbaseorg.hibernate.dialect.PointbaseDialect
PostgreSQLorg.hibernate.dialect.PostgreSQLDialect
Progressorg.hibernate.dialect.ProgressDialect
SAP DBorg.hibernate.dialect.SAPDBDialect
Sybase ASE 15.5org.hibernate.dialect.SybaseASE15Dialect
Sybase ASE 15.7org.hibernate.dialect.SybaseASE157Dialect
Sybase Anywhereorg.hibernate.dialect.SybaseAnywhereDialect
Dialects in Hibernate Framework Dialects in Hibernate Framework Reviewed by Gurugubelli Technologies on December 27, 2016 Rating: 5

No comments:

Subscribe to: Post Comments ( Atom )
Powered by Blogger.