If the following error occurs, it may be that the hibernate SQL dialect (hibernate. dialect) is incorrectly set.
Caused by: Java. SQL. sqlexception: [Microsoft] [sqlserver 2000 driver for JDBC] [sqlserver] 'last _ insert_id 'is not a recognizable function name.
RDBMS |
Dialect |
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 |
SS |
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 |