Hibernate的dialect大全方言。
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” />
|