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. You can read more about this from here
* DB2 – org.hibernate.dialect.DB2Dialect
* HypersonicSQL – org.hibernate.dialect.HSQLDialect
* Informix – org.hibernate.dialect.InformixDialect
* Ingres – org.hibernate.dialect.IngresDialect
* Interbase – org.hibernate.dialect.InterbaseDialect
* Pointbase – org.hibernate.dialect.PointbaseDialect
* PostgreSQL – org.hibernate.dialect.PostgreSQLDialect
* Mckoi SQL – org.hibernate.dialect.MckoiDialect
* Microsoft SQL Server – org.hibernate.dialect.SQLServerDialect
* MySQL – org.hibernate.dialect.MySQLDialect
* Oracle (any version) – org.hibernate.dialect.OracleDialect
* Oracle 9 – org.hibernate.dialect.Oracle9Dialect
* Progress – org.hibernate.dialect.ProgressDialect
* FrontBase – org.hibernate.dialect.FrontbaseDialect
* SAP DB – org.hibernate.dialect.SAPDBDialect
* Sybase – org.hibernate.dialect.SybaseDialect
* Sybase Anywhere – org.hibernate.dialect.SybaseAnywhereDialect
Technorati tags: Hibernate Dialect, ORM
Popularity: 13% [?]
Related posts:
- The Second Level Cache in Hibernate : Settings and Configurations. A Hibernate Session is a transaction-level cache of persistent...
- List of Cache Providers in Hibernate and their Concurrency Support details Here in this port you can find the list...
Related posts brought to you by Yet Another Related Posts Plugin.
5 Responses to “'Hibernate Dialect property' for Different Databases”
Which Dialect will be used if we are connecting through JDBC-ODBC Brij…
If we are using dsn(data source name having db details) ,then whyu we are specifying dialect?
Thank you.
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
[...] ‘Hibernate Dialect property’ for Different Databases Published January 8, 2007 Database , Hibernate , ORM 4 Comments 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 [...]
Leave a Reply: