Database dialect in Hibernate

Source: Internet
Author: User
Tags microsoft sql server 2005 sybase

Specify the dialect that uses the database when you configure Hibernate.cfg.xml:

Cases:

<property name="dialect">org.hibernate.dialect.MySQL5Dialect</ Property>

The following dialects correspond to each database (dialect):

Database

Dialect (dialect)

DB2

Org.hibernate.dialect.DB2Dialect

DB2 as/400

Org.hibernate.dialect.DB2400Dialect

DB2 OS390

Org.hibernate.dialect.DB2390Dialect

PostgreSQL

Org.hibernate.dialect.PostgreSQLDialect

MySQL5

Org.hibernate.dialect.MySQL5Dialect

MySQL5 with InnoDB

Org.hibernate.dialect.MySQL5InnoDBDialect

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

Oracle 11g

Org.hibernate.dialect.Oracle10gDialect

Sybase

Org.hibernate.dialect.SybaseASE15Dialect

Sybase Anywhere

Org.hibernate.dialect.SybaseAnywhereDialect

Microsoft SQL Server 2000

Org.hibernate.dialect.SQLServerDialect

Microsoft SQL Server 2005

Org.hibernate.dialect.SQLServer2005Dialect

Microsoft SQL Server 2008

Org.hibernate.dialect.SQLServer2008Dialect

SAP DB

Org.hibernate.dialect.SAPDBDialect

Informix

Org.hibernate.dialect.InformixDialect

Hypersonicsql

Org.hibernate.dialect.HSQLDialect

H2 Database

Org.hibernate.dialect.H2Dialect

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

Reprint Please specify source: http://blog.csdn.NET/jialinqiang/article/details/8679171

Database dialect in Hibernate

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.