MyBatis操作Oracle的时候，传入null值而引发的错误

Cause: java.lang.reflect.UndeclaredThrowableException]
java.sql.SQLException: 无效的列类型: 1111

Caused by: org.apache.ibatis.type.TypeException:
Error setting null for parameter #2 with JdbcType OTHER .
Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLException: 无效的列类型: 1111

jdbcTypeForNull

 

 

<setting name="jdbcTypeForNull" value="NULL"/>

https://blog.csdn.net/zcaixx/article/details/83349795
https://blog.csdn.net/liyaowen505/article/details/82912535?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromBaidu-3.control&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromBaidu-3.control
https://blog.csdn.net/whandgdh/article/details/99663656?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromBaidu-4.control&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromBaidu-4.control
https://blog.csdn.net/wang873985264/article/details/90234727?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromBaidu-6.control&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromBaidu-6.control
https://blog.csdn.net/qq_30776829/article/details/74408132?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromBaidu-8.control&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromBaidu-8.control
https://www.cnblogs.com/arebirth/archive/2019/08/30/11436432.html