1. 错误代码
session.createSQLQuery(
"insert into teacherdev_basic_young(TEACHERID,FIRST_GRADU_DATE) values(:TEACHERID,:FIRST_GRADU_DATE)")
.setParameter("TEACHERID", "2015")
.setParameter("FIRST_GRADU_DATE", null).executeUpdate();
报错:
org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
2. 正确代码:
session.createSQLQuery(
"insert into teacherdev_basic_young(TEACHERID,FIRST_GRADU_DATE) values(:TEACHERID,:FIRST_GRADU_DATE)")
.setParameter("TEACHERID", "2015")
.setParameter("FIRST_GRADU_DATE", null,Hibernate.TIMESTAMP).executeUpdate();