Hibernate 不同数据库的连接…

  org.hibernate.dialect.MySQLDialect
  com.mysql.jdbc.Driver

  
  jdbc:mysql://localhost/dbname?characterEncoding=gb2312

  
  root

  
  root
  
  
  
  org.hibernate.dialect.SQLServerDialect
  net.sourceforge.jtds.jdbc.Driver

  
  jdbc:jtds:sqlserver://localhost:1433;DatabaseName=dbname

  
  sa

  
  

  
  
  
  org.hibernate.dialect.OracleDialect
  oracle.jdbc.driver.OracleDriver

  
  jdbc:oracle:thin:@localhost:1521:dbname

  
  test

  
  test

如果出现如下错误，则可能是Hibernate SQL方言 (hibernate.dialect)设置不正确。
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]'last_insert_id' 不是可以识别的 函数名。

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

public class OracleDialect extends Oracle10gDialect {

ref="dataSource">

com.ums.dialect.Dialect

true

false

false

false

org.hibernate.hql.internal.ast.ASTQueryTranslatorFactor y

50

50

true

true

true

                org.hibernate.cache.ehcache.EhCacheRegionFactory

com.ums.po