Can't update entity field to null

[RushPVA]

Code sample:

//insert
User user = new User();
user.setUsername("test");
user.setPassword("test");
user.setName("test");
userMapper.insert(user);

//update
user.setPassword("test2");
user.setName(null);
userMapper.update(user);

Password was updated, but name was not.

[yezhoujie]

hi:
it is the strategy when it handle update,it will not to update when a property is null, to make more simpler to update. you just need to set the property which you need to update, so that you don't need to get the whole object with full properties from db.
in your case, you should to use "" or other value to take the place of null.

[easybest]

1. set name with value ""
2. write a update statement in Mapper xml file by yourself

[RushPVA]

may be better to have choice between strategies in configuration? Because updating fields into null is the default strategy for other spring data repositories.

[RushPVA]

1. using "" for empty field is not good aproach for me(for example it ruins not null constraint in data base, also i need additional checks - name != null && !name.isEmpty()
2. i choose spring data to not write boiler plate code, so writing custom xml mappers for simple updates is not right way

[kopax]

I must agree with @RushPVA, it's surprising this update doesn't set to null in database. Would be nice to have both choice.

[RushPVA]

and one more:
ok "" for empty string fields, but what should i set for numbers or dates?