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