mybatis更新拼接的字符串字段报错

2019-10-12 02:15:34 524 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Mybatis，允许更新字段为NULL Data// 使用 IGNORED 策略// 不使用策略注解，将遵循全局配置。阅读详情

Error updating database.  Cause: java.sql.SQLException: sql injection violation, syntax error: ERROR. pos 60, line 2, column 36, token COMMA : update contract_contract

             SET ac_access_groups=,

.001.00 Y.02 M.0 BF.0 BG.0 C6.0 DC.0 DD.0 DE.,

.000.00 Y.02 M.0 BF.0 BG.0 C6.12 W.130. 

             WHERE id = 00158f0b6bee423a9de48146bf582e65

### SQL: update contract_contract              SET ac_access_groups=, .001.00 Y.02 M.0 BF.0 BG.0 C6.0 DC.0 DD.0 DE., .000.00 Y.02 M.0 BF.0 BG.0 C6.12 W.130.               WHERE id = 00158f0b6bee423a9de48146bf582e65

### Cause: java.sql.SQLException: sql injection violation, syntax error: ERROR. pos 60, line 2, column 36, token COMMA : update contract_contract

             SET ac_access_groups=,

.001.00 Y.02 M.0 BF.0 BG.0 C6.0 DC.0 DD.0 DE.,

.000.00 Y.02 M.0 BF.0 BG.0 C6.12 W.130. 

             WHERE id = 00158f0b6bee423a9de48146bf582e65

; uncategorized SQLException; SQL state [null]; error code [0]; sql injection violation, syntax error: ERROR. pos 60, line 2, column 36, token COMMA : update contract_contract

             SET ac_access_groups=,

.001.00 Y.02 M.0 BF.0 BG.0 C6.0 DC.0 DD.0 DE.,

.000.00 Y.02 M.0 BF.0 BG.0 C6.12 W.130. 

             WHERE id = 00158f0b6bee423a9de48146bf582e65; nested exception is java.sql.SQLException: sql injection violation, syntax error: ERROR. pos 60, line 2, column 36, token COMMA : update contract_contract

             SET ac_access_groups=,

.001.00 Y.02 M.0 BF.0 BG.0 C6.0 DC.0 DD.0 DE.,

.000.00 Y.02 M.0 BF.0 BG.0 C6.12 W.130. 

             WHERE id = 00158f0b6bee423a9de48146bf582e65] with root cause

...全文

TLSR8258蓝牙Mesh实战：从SDK下载到自定义通信指令全流程（附避坑指南）本文详细介绍了TLSR8258蓝牙Mesh开发的完整流程，从SDK下载、环境搭建到自定义通信指令的实现。通过实战案例和避坑指南，帮助开发者快速掌握低功耗蓝牙Mesh网络构建技巧，适用于智能家居、工业监控等物联网场景。阅读详情

御命丹心君奉天

Java EE 67,535 成员 225,843 内容

+ 关注 + 加入社区

mybatis更新拼接的字符串字段报错

相关推荐