Hibernate對各數據庫的連接方言

<sessionfactory>
 <property name=connectiondriver_class>netsourceforgejtdsjdbcDriver</property>
 <property name=connectionurl>jdbc:jtds:sqlserver://ALEX:/News</property>
 <!for oracle
 <property name=dialect>orghibernatedialectOracleDialect</property>
 >
 <!for Mysql
 <property name=dialect>orghibernatedialectMySQLDialect</property>
 >
 <!for Ms SQL Server>
 <property name=dialect>orghibernatedialectSQLServerDialect</property>
 <property name=connectionusername>sa</property>
 <property name=connectionpassword>sa</property>
 <property name=show_sql>true</property>
</sessionfactory>
 
RDBMS  方言 
DB  orghibernatedialectDBDialect 
DB AS/  orghibernatedialectDBDialect 
DB OS  orghibernatedialectDBDialect 
PostgreSQL  orghibernatedialectPostgreSQLDialect 
MySQL  orghibernatedialectMySQLDialect 
MySQL with InnoDB  orghibernatedialectMySQLInnoDBDialect 
MySQL with MyISAM  orghibernatedialectMySQLMyISAMDialect 
Oracle (any version)  orghibernatedialectOracleDialect 
Oracle i/g  orghibernatedialectOracleDialect 
Sybase  orghibernatedialectSybaseDialect 
Sybase Anywhere  orghibernatedialectSybaseAnywhereDialect 
Microsoft SQL Server  orghibernatedialectSQLServerDialect 
SAP DB  orghibernatedialectSAPDBDialect 
Informix  orghibernatedialectInformixDialect 
HypersonicSQL  orghibernatedialectHSQLDialect 
Ingres  orghibernatedialectIngresDialect 
Progress  orghibernatedialectProgressDialect 
Mckoi SQL  orghibernatedialectMckoiDialect 
Interbase  orghibernatedialectInterbaseDialect 
Pointbase  orghibernatedialectPointbaseDialect 
FrontBase  orghibernatedialectFrontbaseDialect 
Firebird  orghibernatedialectFirebirdDialect
From:http://tw.wingwit.com/Article/program/Java/ky/201311/27952.html