‘Hibernate Dialect property’ for Different Databases

Hibernate is the most common and famous ORM using these days. It has a property called “Dialect” through which we tells Hibernate that we are using ‘this specific’ database. Here in this post you can see the dialect property values which we have to give for different databases.
Click here to Read Full Article

7 thoughts on “‘Hibernate Dialect property’ for Different Databases

  1. I am getting proper result for my query.
    I think this site will help to the enduser who does not know about the hibernate .


    1. Hi all

      The dialect in hibernate is a class that is used to connect to particular Database. so for each DB we have to use different dialect.

      following is the list of Dialects provided by hibernate to connect different databases.

      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 –> org.hibernate.dialect.Oracle9iDialect
      Oracle 10g –> org.hibernate.dialect.Oracle10gDialect
      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

  2. If we are using dsn(data source name having db details) ,then whyu we are specifying dialect?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: