Hibernate的dialect大全

RDBMS方言

DB2org.hibernate.dialect.DB2Dialect

DB2AS/400org.hibernate.dialect.DB2400Dialect

DB2OS390org.hibernate.dialect.DB2390Dialect

PostgreSQLorg.hibernate.dialect.PostgreSQLDialect

MySQLorg.hibernate.dialect.MySQLDialect

MySQLwithInnoDBorg.hibernate.dialect.MySQLInnoDBDialect

MySQLwithMyISAMorg.hibernate.dialect.MySQLMyISAMDialect

Oracle(anyversion)org.hibernate.dialect.OracleDialect

Oracle9i/10gorg.hibernate.dialect.Oracle9Dialect

Sybaseorg.hibernate.dialect.SybaseDialect

SybaseAnywhereorg.hibernate.dialect.SybaseAnywhereDialect

MicrosoftSQLServerorg.hibernate.dialect.SQLServerDialect

SAPDBorg.hibernate.dialect.SAPDBDialect

Informixorg.hibernate.dialect.InformixDialect

HypersonicSQLorg.hibernate.dialect.HSQLDialect

Ingresorg.hibernate.dialect.IngresDialect

Progressorg.hibernate.dialect.ProgressDialect

MckoiSQLorg.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

例子：

<propertyname="hibernate.connection.username"value="sa"/>

<propertyname="hibernate.connection.password"value="sa"/>

<propertyname="hibernate.connection.url"value="jdbc:sqlserver://localhost:1433;databaseName=test"/>

<propertyname="hibernate.connection.driver_class"value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>

<propertyname="hibernate.cache.provider_class"value="org.hibernate.cache.NoCacheProvider"/>

<propertyname="hibernate.dialect"value="org.hibernate.dialect.SQLServerDialect"/>

<propertyname="hibernate.dialect"value="org.hibernate.dialect.SQLServerDialect"/>

如果是Toplink则添加：

<propertyname="toplink.jdbc.user"value="sa"/>

<propertyname="toplink.jdbc.password"value="sa"/>

<propertyname="toplink.jdbc.url"value="jdbc:mysql://localhost:3306/test"/>

<propertyname="toplink.jdbc.driver"value="com.mysql.jdbc.Driver"/>

<propertyname="toplink.plafrom.class.name"value="oracle.toplink.essentials.platform.database.HSQLPlatform"/>