在向某个表中插入数据时出错,错误如下:
org.springframework.dao.InvalidDataAccessResourceUsageException: could not insert: [com.sxpt.model.Stutogrp]; SQL [insert into sxpt_bs.stutogrp (ischeck, isheadman, grpid, uloginid, using) values (?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not insert: [com.sxpt.model.Stutogrp]
Caused by: java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to usenear 'using) values (0, 1, 5, '201000834102', 1)' at line 1
检查发现hibernate插入数据时出错,而且根据错误信息可以看出错误原因在于sql语句语法错误,根据错误提示拼接出hiernate提交给数据库的语句:
insert into sxpt_bs.stutogrp (ischeck, isheadman, grpid, uloginid, using) values (0, 1, 5, '201000834102', 1)
检查语法、表明、字段拼写没有明显错误(搞了几年编程了,这个还是可以肯定的)。在mysql中执行,发现错误提示与上边基本一样,按照提示 'using) values...