Hibernate不同数据库的连接及 SQL方言
<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