pg数据库下 用户管理功能 报错,可能是字段类型不对?

提问 0 989
caoyingde
caoyingde 2021-04-06
版本:renren-security 开发环境:
### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying 建议:No operator matches the given name and argument type(s). You might need to add explicit type casts. 位置:129 ### The error may exist in io/platform/modules/sys/dao/SysPostDao.java (best guess) ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT id,post_code,post_name,sort,status,updater,update_date,tenant_code,creator,create_date FROM sys_post WHERE (status = ? AND tenant_code = ?) ORDER BY sort ASC ### Cause: org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying 建议:No operator matches the given name and argument type(s). You might need to add explicit type casts. 位置:129 ; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying 建议:No operator matches the given name and argument type(s). You might need to add explicit type casts. 位置:129 org.springframework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying 建议:No operator matches the given name and argument type(s). You might need to add explicit type casts. 位置:129 ### The error may exist in io/platform/modules/sys/dao/SysPostDao.java (best guess) ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT id,post_code,post_name,sort,status,updater,update_date,tenant_code,creator,create_date FROM sys_post WHERE (status = ? AND tenant_code = ?) ORDER BY sort ASC ### Cause: org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying 建议:No operator matches the given name and argument type(s). You might need to add explicit type casts. 位置:129 ; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying 建议:No operator matches the given name and argument type(s). You might need to add explicit type casts. 位置:129
回帖
  • 消灭零回复