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" />
|
源地址:http://qsfwy.iteye.com/blog/471858