Error querying database. Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.D
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:### Error querying database.Cause: java.lang.IllegalArgumentException: invalid comparis
·
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String
### Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
at com.sun.proxy.$Proxy137.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76)
这种报错就是在编写sql是日期格式不正确,我比较粗心经常忘记,在这里提醒一下
<if test="date != null and date != ''">
DATE = #{date}
</if>
这样话会报错,因为date是日期类型,所以改为以下这样就好了
<if test="date != null">
DATE = #{date}
</if>
更多推荐
已为社区贡献1条内容
所有评论(0)