org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
【MyBatisSystemException 异常】net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "," ","
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException:.....
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "," ","
at line 1, column 164.
Was expecting one of:
"&"
"::"
";"
"<<"
">>"
"ACTION"
............................................................................
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT id,parent_id,`code`,user_id,`type`,source,title,content,end_time,finish_time,contact_id,sid,business_key,urgency,`status`,remind,reminder_show,reminder_time,keep,keep_check,keep_fre,keep_fre_rule,keep_weeks,keep_months,keep_start_date,keep_end_date,tenant_id,create_time,update_time,creator,updater,deleted FROM crm_task WHERE id=? AND deleted=0 ### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT id,parent_id,`code`,user_id,`type`,source,title,content,end_time,finish_time,contact_id,sid,business_key,urgency,`status`,remind,reminder_show,reminder_time,keep,keep_check,keep_fre,keep_fre_rule,keep_weeks,keep_months,keep_start_date,keep_end_date,tenant_id,create_time,update_time,creator,updater,deleted FROM crm_task WHERE id=? AND deleted=0 at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.$Proxy151.selectOne(Unknown Source) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151) ... 176 common frames omitted Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "," "," at line 1, column 164. Was expecting one of: "&" "::" ";" "<<" ">>" "ACTION" "ACTIVE" "ALGORITHM" "ARCHIVE"
【问题】执行查询接口第一次请求失败,第二次成功问题。
【原因】经过一步步排查,终于找到bug原因了,竟然是mysql关键词冲突原因!!!
实体类DO里面使用了mysql的关键词,造成了解析错误原因。
【解决】解决方法,在属性字段上添加 @TableField 注解
@TableField("`keep`") private Boolean keep;
【结果】
bug怎么这么多!
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章
· 没有源码,如何修改代码逻辑?
· PowerShell开发游戏 · 打蜜蜂
· 在鹅厂做java开发是什么体验
· WPF到Web的无缝过渡:英雄联盟客户端的OpenSilver迁移实战
2021-12-09 gitLab生成SSH私钥后上传代码及获取代码