Query condition modification, comment out the old sql, resulting in an error
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property=’command.bldgLevel’, mode=IN, javaType=class java.lang.Object, jdbcType=VARCHAR, numericScale=null, resultMapId=’null’, jdbcTypeName=’null’, expression=’null’}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 with JdbcType VARCHAR . Try setting a different JdbcType for this parameter or a different configuration property. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 with JdbcType VARCHAR . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
Solution:
Remove useless comments
Read More:
- Mapper.xml Error: Error setting non null for parameter #3 with JdbcType null.
- [Solved] mybatis plus Insert Error: mybatis plus Error setting null for parameter #1 with JdbcType OTHER
- [Solved] Java.lang.IllegalStateException: Type handler was null on parameter mapping for property ‘__frch_it
- [Solved] Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException
- Mybatis single parameter pass in exception (How to Fix)
- [Solved] mybatis Error querying database. Cause: java.sql.SQLException: The server time zone value
- Mybatis Error: The error may exist in xxxxMapper.xml [How to Solve]
- [Solved] Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration
- Build a mybatis and it will appear session.selectOne Method error
- o.s.boot.SpringApplication, Error creating bean with name ‘paymentImpl‘, xml Configuration file error
- [Solved] Mybatis Error: attempting to get column ‘XX’ from result set
- Hibernate Error: Error executing DDL “create table course (xxx)“
- [Solved] Error updating database. Cause: java.sql.SQLException: Incorrect integer value: ‘**‘ for column
- [Solved] Specified key was too long; max key length is 767 bytes
- Mybatis reports an error (error building sqlsession.) when using annotations without deleting redundant files
- org.springframework.http.converter.HttpMessageNotReadableException: JSON parse error: Cannot deseria
- springboot sqlserver druid reward: validateConnection false
- [Solved] Mybatis insert Error: Cause: java.sql.SQLException: SQL String cannot be empty
- [Solved] org.apache.ibatis.exceptions.PersistenceException: ### Error building SqlSession…
- Mybatis plus configuration console prints complete SQL statement with parameters