mybaitsplus saveBatch 空指针问题排查

1. 首先肯定是看传递过去的集合是否真的为空
2. 在这一点百分比确定的情况下，就可以去排查一下是否有某个字段超长了，数据库这边的设置太短了，我这边碰到的问题一个字段本来使用的是 varchar2(4000)，但是没曾想业务那边提交过来的数据既然超过了。然后还一直在报错

java.lang.NullPointerException: null
	at java.util.Objects.requireNonNull(Objects.java:203) ~[na:1.8.0_231]
	at com.baomidou.mybatisplus.extension.toolkit.SqlHelper.executeBatch(SqlHelper.java:185) ~[mybatis-plus-extension-3.4.2.jar!/:3.4.2]
	at com.baomidou.mybatisplus.extension.toolkit.SqlHelper.executeBatch(SqlHelper.java:207) ~[mybatis-plus-extension-3.4.2.jar!/:3.4.2]
	at com.baomidou.mybatisplus.extension.service.impl.ServiceImpl.executeBatch(ServiceImpl.java:239) ~[mybatis-plus-extension-3.4.2.jar!/:3.4.2]
	at com.baomidou.mybatisplus.extension.service.impl.ServiceImpl.saveBatch(ServiceImpl.java:135) ~[mybatis-plus-extension-3.4.2.jar!/:3.4.2]
	at com.baomidou.mybatisplus.extension.service.IService.saveBatch(IService.java:73) ~[mybatis-plus-extension-3.4.2.jar!/:3.4.2]
	at com.baomidou.mybatisplus.extension.service.IService$$FastClassBySpringCGLIB$$f8525d18.invoke(<generated>) ~[mybatis-plus-extension-3.4.2.jar!/:3.4.2]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.21.jar!/:5.3.21]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) ~[spring-aop-5.3.21.jar!/:5.3.21]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.21.jar!/:5.3.21]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.21.jar!/:5.3.21]
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) ~[spring-tx-5.3.21.jar!/:5.3.21]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) ~[spring-tx-5.3.21.jar!/:5.3.21]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.21.jar!/:5.3.21]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.21.jar!/:5.3.21]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.21.jar!/:5.3.21]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.21.jar!/:5.3.21]

 我也是找了将近一个小时，又是调试又是分析的，最后在一个小哥那边看到了这个问题

这个报错魅惑性太强了

mybaitsplus saveBatch 空指针 - 简书 

 后台我把varchar2改成clob就ok了。但是不能直接修改，要做一个过渡。

这里顺便说一下修改的方案

1. --直接把 varchar2 修改为 clob 类型会报错-ORA-22858: 数据类型的变更无效
2. --添加列
3. alter table test_v_hwhao add CLASSNAME_TEMP clob;
4. --把要修改列的值赋值给新加的列
5. update test_v_hwhao set CLASSNAME_TEMP = CLASSNAME;
6. commit;
7. --删除要修改的列
8. alter table test_v_hwhao drop column CLASSNAME;
9. --把新加的列名称改为旧列名称
10. alter table test_v_hwhao rename column CLASSNAME_TEMP to CLASSNAME;