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:

• Mybatis-plus: How to Execute Native SQL
• [Solved] Mybatis insert Error: Cause: java.sql.SQLException: SQL String cannot be empty
• Mybatis single parameter pass in exception (How to Fix)
• Mybatis query error: Exception in thread “main” org.apache.ibatis.exceptions.PersistenceException…
• How to Solve Linux connecte to the old version of SQL Server Error
• How to Solve mybatis-plus Paging Plug-in PaginationInnerInterceptor error
• How to Solve Mybatis error: invalid bound statement (not found)
• [Solved] mybatis Error querying database. Cause: java.sql.SQLException: The server time zone value
• [Solved] java.sql.SQLException: Unknown system variable cache query size
• Mybatis plus configuration console prints complete SQL statement with parameters
• [Solved] Mybatis add dependencies Error: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration.
• [Solved] mybatis plus Insert Error: mybatis plus Error setting null for parameter #1 with JdbcType OTHER
• How to Solve JDBC connection error in spring MVC integration
• [Solved] Mybatis Error: Could not find resource mybatis-conf.xml
• How to Solve classnotfoundexception error in spark without Hadoop runtime
• [Solved] Mybatis.generator error: Failed to execute goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.2
• How to Solve zipkin Install Error in Windows
• How to Solve Image Upload Error: Uncaught (in promise) DOMException: Failed to execute ‘put‘ on ‘IDBObjectStore‘
• How to Solve Tomcat Error: Could not resolve view with name ‘xxx/xxxxxxx‘ in servlet with
• How to Solve Error executing DDL in JPA