Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration ...

1.  
   org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='__frch_item_0.paymentDate', mode=IN, javaType=class java.util.Date, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting null for parameter #17 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLException: 無效的資料欄類型: 1111
2.  
   at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:78)
3.  
   at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
4.  
   at com.sun.proxy.$Proxy239.insert(Unknown Source)
5.  
   at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:271)
6.  
   at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:58)
7.  
   at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:61)
8.  
   at com.sun.proxy.$Proxy260.saveBatch(Unknown Source)
9.  
   at com.**.**.remittance.service.ScheduleService.booking2RemitTask(ScheduleService.java:973)
10.  
    at com.**.**.remittance.service.ScheduleService$$FastClassBySpringCGLIB$$602ffb41.invoke(<generated>)
11.  
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
12.  
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
13.  
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
14.  
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
15.  
    at org.springframework.cloud.sleuth.instrument.scheduling.TraceSchedulingAspect.traceBackgroundThread(TraceSchedulingAspect.java:69)
16.  
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
17.  
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
18.  
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
19.  
    at java.lang.reflect.Method.invoke(Method.java:498)
20.  
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
21.  
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
22.  
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
23.  
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
24.  
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
25.  
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
26.  
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
27.  
    at com.**.**.remittance.service.CipsScheduleService$$EnhancerBySpringCGLIB$$1d0459c2.booking2RemitTask(<generated>)
28.  
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
29.  
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
30.  
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
31.  
    at java.lang.reflect.Method.invoke(Method.java:498)
32.  
    at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
33.  
    at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
34.  
    at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:93)
35.  
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
36.  
    at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
37.  
    at java.util.concurrent.FutureTask.run(FutureTask.java)
38.  
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
39.  
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
40.  
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
41.  
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
42.  
    at java.lang.Thread.run(Thread.java:750)

解决：

明确字段类型

  如果数据库表语句字段不为空，要么调用处判断，要么设默认值!!!

这篇好文章是转载于：学新通技术网