当前位置:   article > 正文

【bug】Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown error 1054

java.sql.sqlsyntaxerrorexception: unknown error 1054

org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Unknown error 1054
### The error may exist in com/mia/system/mapper/SysRoleMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT  id,role_name,role_code,description,create_time,update_time,is_deleted  FROM sys_role   WHERE  is_deleted=0  AND (role_cole = ?)
### Cause: java.sql.SQLSyntaxErrorException: Unknown error 1054
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown error 1054

错误原因:参数错误

解决方法:数据表的列名直接从文档中复制,正确列名:role_code

本文内容由网友自发贡献,转载请注明出处:【wpsshop博客】
推荐阅读
相关标签
  

闽ICP备14008679号