'Hibernate Dialect property' for Different Databases

Add a comment January 8th, 2007 Lijin

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

Book Mark it-> del.icio.us | Reddit | Slashdot | Digg | Facebook | Technorati | Google | StumbleUpon | Window Live | Tailrank | Furl | Netscape | Yahoo | BlinkList

Popularity: 12% [?]

Bookmark this on BuzzURLBookmark this on BuzzURL Post to TwitterTweets for this web page Bookmark this on FC2 Bookmark newsing it! Choix it! Add to Google Bookmark Bookmark this on Delicious Digg This

Related posts:

  1. The Second Level Cache in Hibernate : Settings and Configurations. A Hibernate Session is a transaction-level cache of persistent data....
  2. List of Cache Providers in Hibernate and their Concurrency Support details Here in this port you can find the list of...

Related posts brought to you by Yet Another Related Posts Plugin.

Database, Hibernate, ORM
  1. September 30th, 2007 at 02:22 | #1
    M. Asif

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

  2. July 26th, 2008 at 14:05 | #2
    Vrushali

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

  3. July 31st, 2008 at 20:20 | #3
    Yusuf

    Thank you.

  4. February 6th, 2009 at 12:38 | #4
    Amudha

    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

  1. |
    July 9th, 2009 at 04:27 | #1
    ‘Hibernate Dialect property’ for Different Databases « Lijin’s Localhost

    [...] ‘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 [...]
Comments feed