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] 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)
• Mybatis Error: The error may exist in xxxxMapper.xml [How to Solve]
• 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)“
• Mybatis reports an error (error building sqlsession.) when using annotations without deleting redundant files
• [Solved] Specified key was too long; max key length is 767 bytes
• org.springframework.http.converter.HttpMessageNotReadableException: JSON parse error: Cannot deseria
• springboot sqlserver druid reward: validateConnection false
• Mybatis plus configuration console prints complete SQL statement with parameters
• Extracting JDBC tool class: JDBC utils
• Mybatis Error: Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance.
• [Solved] Mybatis Error: Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance.
• [Solved] Mybatis add dependencies Error: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration.
• Using mybatis statement.getGenreatedKeys(); usegeneratedkeys = “true”; using self incrementing primary key to get primary key value policy and Oracle do not support self incrementing, Oracle uses sequence
• [Solved] Could not find resource COM / atguigu / Dao / studentdao.xm, the mapper file for storing SQL statements could not be found and an error occurred