Mybatis-plus之空值无法插入
异常如下:
org.mybatis.spring.MyBatisSystemException: nested exception is
org.apache.ibatis.type.TypeException: Could not set parameters for mapping:
ParameterMapping{property='couldDismantle', mode=IN, javaType=class java.lang.Long,
jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null',
expression='null'}. Cause: org.apache.ibatis.type.TypeException: JDBC requires that the
JdbcType must be specified for all nullable parameters.
出现这种自生成代码的insert无法写入值为空的数据,有以下两种解决办法:
方法1:
yml配置文件配置如下:
mybatis-plus:
configuration:
jdbc-type-for-null: 'null' #注意:单引号
方法2:
查看mp-starter-源码, MybatisPlusAutoConfiguration, 可以发现,第119行有一个configurationCustomizers,可以修改configuration
自定义一个,配上就完工
@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); }
方法3:
通过Java配置文件设置
@Configuration
@MapperScan(basePackages = {"com.XXXX.mapper"}, sqlSessionFactoryRef = "XXXXXX")
public class DbYYConfig {
@Autowired
@Qualifier("XXXX")
private DataSource dataSourceDb2;
@Bean
public SqlSessionFactory sqlSessionFactoryDb2() throws Exception {
SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
factoryBean.setDataSource(dataSourceDb2);
factoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mapper/*.xml"));
org.apache.ibatis.session.Configuration configuration = new org.apache.ibatis.session.Configuration();
configuration.setMapUnderscoreToCamelCase(true);
configuration.setJdbcTypeForNull(JdbcType.NULL);
factoryBean.setConfiguration(configuration);
return factoryBean.getObject();
}
@Bean
public SqlSessionTemplate sqlSessionTemplateDb2() throws Exception {
return new SqlSessionTemplate(sqlSessionFactoryDb2());
}
}