< !--MySql 驅動程序 eg. mysql-connector-java-5.0.4-bin.jar-->
< property name="dialect">org.hibernate.dialect.MySQLDialect< /property>
< property name="connection.driver_class">com.mysql.jdbc.Driver< /property>
< !-- JDBC URL -->
< property name="connection.url">jdbc:mysql://localhost/dbname?characterEncoding=gb2312< /property>
< !-- 數據庫用戶名-->
< property name="connection.username">root< /property>
< !-- 數據庫密碼-->
< property name="connection.password">root< /property>
< !--Sql Server 驅動程序 eg.jtds-1.2.jar-->
< property name="dialect">org.hibernate.dialect.SQLServerDialect< /property>
< property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver< /property>
< !-- JDBC URL -->
< property name="connection.url">jdbc:jtds:sqlserver://localhost:1433;DatabaseName=dbname< /property>
< !-- 數據庫用戶名-->
< property name="connection.username">sa< /property>
< !-- 數據庫密碼-->
< property name="connection.password">< /property>
< !--Oracle 驅動程序 ojdbc14.jar-->
< property name="dialect">org.hibernate.dialect.OracleDialect< /property>
< property name="connection.driver_class">oracle.jdbc.driver.OracleDriver< /property>
< !-- JDBC URL -->
< property name="connection.url">jdbc:oracle:thin:@localhost:1521:dbname< /property>
< !-- 數據庫用戶名-->
< property name="connection.username">test< /property>
< !-- 數據庫密碼-->
< property name="connection.password">test< /property>
|
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 |