mybatis中Oracle参数为NULL错误问题及解决

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

select * from tb where name = #{name,jdbcType=NULL}

mybatis:
  mapper-locations: classpath:mapping/*/*.xml
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    call-setters-on-nulls: true
    jdbc-type-for-null: 'null'

@Bean
    public ConfigurationCustomizer configurationCustomizer(){
        return new MybatisPlusCustomizers();
    }
 
    class MybatisPlusCustomizers implements ConfigurationCustomizer {
 
        @Override
        public void customize(org.apache.ibatis.session.Configuration configuration) {
            configuration.setJdbcTypeForNull(JdbcType.NULL);
        }

@TableField(el = "username, jdbcType=VARCHAR")

@Email
@TableField(el = "email, jdbcType=VARCHAR")
private String email;

this.baseMapper.updateAllColumnById(user);