Hiernate SQL方言

andy136566

如果出现如下错误，则可能是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

[转]http://shen198623.iteye.com/blog/245358