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