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" />