Hibernate的dialect大全

最新推荐文章于 2019-07-20 20:38:14 发布

原创最新推荐文章于 2019-07-20 20:38:14 发布 · 130 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Hibernate #Sybase #DB2 #MySQL #Oracle

Hibernate 专栏收录该内容

1 篇文章

订阅专栏

本文详细介绍了Hibernate中针对不同关系型数据库的方言配置方法，包括DB2、PostgreSQL、MySQL等主流数据库的方言设置及示例。

RDBMS 方言
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/10g org.hibernate.dialect.Oracle9Dialect
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

Access数据库的方言包：http://www.hxtt.com/test/hibernate.zip
路径：com.hxtt.support.hibernate.HxttAccessDialect

例子：
<property name="hibernate.connection.username" value="sa"/>
<property name="hibernate.connection.password" value="sa"/>
<property name="hibernate.connection.url" value="jdbc:sqlserver://localhost:1433;databaseName=test"/>
<property name="hibernate.connection.driver_class" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<property name="hibernate.cache.provider_class" value="org.hibernate.cache.NoCacheProvider"/>
<property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect"/>

<property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect"/>

如果是Toplink则添加：

<property name="toplink.jdbc.user" value="sa"/>
<property name="toplink.jdbc.password" value="sa"/>
<property name="toplink.jdbc.url" value="jdbc:mysql://localhost:3306/test"/>
<property name="toplink.jdbc.driver" value="com.mysql.jdbc.Driver"/>
<property name="toplink.plafrom.class.name" value="oracle.toplink.essentials.platform.database.HSQLPlatform" />