Mybatis-Plus 更新字段为 Null 的坑

1
2
3
4
5
6
7
8
9

// 实体类字段设置
@TableField(value = "LOCK_EXP_TIME_", updateStrategy = FieldStrategy.IGNORED)
private Date lockExpirationTime;

// mapper操作
JobEntity jobEntity = new JobEntity();
jobEntity.setId(1);
jobEntity.setLockExpirationTime(null);
JobEntityMapper.updateById(jobEntity);

1

### Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='et.lockExpirationTime', mode=IN, javaType=class java.lang.Object, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: 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. 

1
2
3

// 添加 jdbcType
@TableField(value = "LOCK_EXP_TIME_", updateStrategy = FieldStrategy.IGNORED, jdbcType = JdbcType.TIMESTAMP)
private Date lockExpirationTime;

1
2
3
4
5

try {
    typeHandler.setParameter(ps, i + 1, value, jdbcType);
} catch (TypeException | SQLException e) {
    throw new TypeException("Could not set parameters for mapping: " + parameterMapping + ". Cause: " + e, e);
}