Error querying database syntax error at or near “$1”
查询数据库时出错 第1个参数附件语法错误
↵### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1"↵ 位置:665
↵### The error may exist in file [E:\demo\service\target\classes\\DemoMapper.xml]
↵### The error may involve defaultParameterMap
↵### The error occurred while setting parameters
↵### SQL: select id, name, sex, age from "TB1" where age between ? and ? and name = ? and sex ?
↵### Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "$4"↵ 位置:665↵; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near "$4"↵ 位置:665"
第1个参数附件语法错误 ,请检查第一个参数是有问题 mapper接口方法中是否传了该参数。