日期:2014-05-16  浏览次数:20545 次

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