RDBMS 方言



DB2org.hibernate.dialect.DB2Dialect
DB2 AS/400org.hibernate.dialect.DB2400Dialect
DB2 OS390org.hibernate.dialect.DB2390Dialect
PostgreSQLorg.hibernate.dialect.PostgreSQLDialect
MySQLorg.hibernate.dialect.MySQLDialect
MySQL with InnoDBorg.hibernate.dialect.MySQLInnoDBDialect
MySQL with MyISAMorg.hibernate.dialect.MySQLMyISAMDialect
Oracle (any version)org.hibernate.dialect.OracleDialect
Oracle 9i/10gorg.hibernate.dialect.Oracle9Dialect
Sybaseorg.hibernate.dialect.SybaseDialect
Sybase Anywhereorg.hibernate.dialect.SybaseAnywhereDialect
Microsoft SQL Serverorg.hibernate.dialect.SQLServerDialect
SAP DBorg.hibernate.dialect.SAPDBDialect
Informixorg.hibernate.dialect.InformixDialect
HypersonicSQLorg.hibernate.dialect.HSQLDialect
Ingresorg.hibernate.dialect.IngresDialect
Progressorg.hibernate.dialect.ProgressDialect
Mckoi SQLorg.hibernate.dialect.MckoiDialect
Interbaseorg.hibernate.dialect.InterbaseDialect
Pointbaseorg.hibernate.dialect.PointbaseDialect
FrontBaseorg.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" />


转自:http://qsfwy.iteye.com/blog/471858