Database Hibernate ORM

‘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 replies on “‘Hibernate Dialect property’ for Different Databases”

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


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

Leave a Reply

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

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

Google photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s