首页 / 软件开发 / JAVA / Hibernate对各数据库的连接方言

<session-factory>  <property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>  <property name="connection.url">jdbc:jtds:sqlserver://ALEX:1134/News</property>  <！--for oracle 9 <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>  -->  <！--for Mysql  <property name="dialect">org.hibernate.dialect.MySQLDialect</property>  -->  <！--for Ms SQL Server-->  <property name="dialect">org.hibernate.dialect.SQLServerDialect</property>  <property name="connection.username">sa</property>  <property name="connection.password">sa</property>  <property name="show_sql">true</property> </session-factory>   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