Caused by: org.apache.ibatis.type.TypeException: Error setting non null for parameter #15 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (15 > number of parameters, which is 14).
at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:71)
at com.baomidou.mybatisplus.core.MybatisDefaultParameterHandler.setParameters(MybatisDefaultParameterHandler.java:227)
... 88 more
Caused by: java.sql.SQLException: Parameter index out of range (15 > number of parameters, which is 14).
If a comment SQL fragment exists in the SQL code, the #{} parameter cannot be used in the comment SQL fragment. As follows:
on t1.dealer_code = t4.dealer_code
-- left join (
-- select
-- ads_code
-- ,sum(case when car like '%MM%' or model = 'MM' then ss_num else 0 end) as ws_MM_num
-- from abc_assss_ss
-- where seq = 1 and count_date between '2021-04-01' and '2021-06-30'
-- group by
-- dealer_code
-- )t2
-- on t1.asd_code = t2.ads_code
)
select
~~~
If you replace the between and with the parameter between #{start_time} and #{end_time}, it will report this error, hope it can solve your problem
Read More:
- [Solved] MySQL: datetime (0) null default NULL
- Front end error: exceptionmessage: null [How to Solve]
- Cause: java.sql.SQLException: ORA-01407: Unable to update (“MESIRJ”.”TMMIC01″.”RDEL”) is NULL
- [Solved] public key is not available client side (option serverRsaPublicKeyFile not set)
- Can mybatis prevent SQL injection
- Oracle creates a job and executes the stored procedure with parameters regularly
- The setobject() method reports an error. The parameter index out of range and MySQL syntax error exception report an error
- Mybatis Add Datas error: ERROR: Field * doesn‘t have a default value
- Kettle stores data report ora-00600 to Oracle: internal error parameters [KQD object $], [u], [0], [107], [CS], []
- MYSQL Slave is not configured or failed to initialize properly. You must at least set –server-id
- [MySQL] Note that MySQL5.1 does not support utf8mb4 Error 1115: Unknown character set:’utf8mb4′
- Mybatis Error: The server time zone value ‘����1532a0’ is unrecognized
- Mysql + Mybatis Batch Update Datas Error: BadSqlGrammarException
- Cannot resolve classpath entry: e://jar/mysql-connector-java-5.1.17-bin mybatis error in reverse engineering
- [Solved] The number of rows returned by the mybatis UPDATE statement is always 1 or useaffectedrows = true
- Error [err] is reported when redirecting_HTTP_HEADERS_SENT]: Cannot set headers after they are sent to the client
- linux mysql ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- Using Mybatis to connect to the database error: Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver···
- MySQL character set error resolution: err=Error 3988: Conversion from collation utf8mb4_unicode_ci into utf8_general_ci impo
- MYSQL8 Startup Error: mysqld_safe error: log-error set to ‘/var/log/mariadb/mariadb.log‘