‘Hibernate Dialect property’ for Different Databases

Lijin8 Jan 20079 Jul 2009Database, Hibernate, ORM

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”

Java Developer says:

12 Sep 2013 at 11:52 pm

Find all database related dialect for Hibernate : http://www.visionsdeveloper.com/blog/page/dialect-use-in-hibernate.jsp‎

Reply
1. Java Developer says:
  
  12 Sep 2013 at 11:54 pm
  
  http://www.visionsdeveloper.com/blog/page/dialect-use-in-hibernate.jsp‎
  
  Reply
Amudha says:

6 Feb 2009 at 12:38 pm

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

Thanks

Reply
1. cupid says:
  
  8 Aug 2011 at 5:09 pm
  
  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
  
  Reply
Yusuf says:

31 Jul 2008 at 8:20 pm

Thank you.

Reply
Vrushali says:

26 Jul 2008 at 2:05 pm

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

Reply
M. Asif says:

30 Sep 2007 at 2:22 am

Which Dialect will be used if we are connecting through JDBC-ODBC Brij…

Reply

Share this:

Like this:

Related

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

Leave a Reply Cancel reply