项目中向mysql数据库做更新操作报错

来源：互联网发布：五十音图软件编辑：程序博客网时间：2024/05/22 08:25

根据表中的某个字段查询出了一个list列表，然后取第一个元素做更新操作，竟然报错了，错误如下：

Hibernate: select odesktopmo0_.id as id1_1_, odesktopmo0_.key as key2_1_, odesktopmo0_.licenseId as licenseI3_1_, odesktopmo0_.licenseName as licenseN4_1_, odesktopmo0_.licenseSeriesName as licenseS5_1_, odesktopmo0_.username as username6_1_ from o_desktop odesktopmo0_ where odesktopmo0_.username=?

Hibernate: update o_desktop set key=?, licenseId=?, licenseName=?, licenseSeriesName=?, username=? where id=?
2017-04-27 17:41:15 [ http-apr-8080-exec-4:57235 ] - [ WARN ] SQL Error: 1064, SQLState: 42000
2017-04-27 17:41:15 [ http-apr-8080-exec-4:57235 ] - [ ERROR ] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key='EVA64959', licenseId='e761dd0f298944dcab22d1e888c60293', licenseName='d' at line 1
2017-04-27 17:41:15 [ http-apr-8080-exec-4:57236 ] - [ INFO ] HHH000010: On release of batch it still contained JDBC statements

org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement

好吧，看到这个错误的时候，我以为是我的代码出了问题，然后各种的找原因，后来发现确实找不到原因，果断上网查询资料，发现这个错误其实就是我操作的数据库表中的某个字段的名字使用了关键字，以后设计数据库的时候表名和字段名一定要注意了。

0 0