How to ignore certain column from being fetched when using findBy.. in JPA

Question

I have a User entity which has all the user's data including the password hash. I also have an API getUserDetails which performs a simple userRepository.findById(id) to get all the user's data. However, in the process it also returns the password hash which I don't want to.

One way to remove the password hash is to remove it from the service layer after all the data has been fetched. Like this -

fun getUserDetails(id: Long): Optional<User> {
        val user: Optional<User> = userRepository.findById(id)
        user.get().password = ""
        return user
    }

The output will be like this -

{
  "id": 4,
  "roles": "ADMIN",
  "userName": "user3",
  "emailId": "hello@outlook.com",
  "password": "",
  "phoneNumber": "1234",
  "organisationName": "test",
  "isActive": true
}

The password value has been removed but the key still exists. I would like to get rid of that too.

Is there any other way which is more baked into JPA which I can use to achieve the said result?

But won't that ignore it for all the queries? What about when I actually need the hash? — krtkush, Aug 08 '20 at 10:26
This worked. Please put this up as an answer and I'll mark it correct. — krtkush, Aug 08 '20 at 10:33

score 1 · Answer 1 · answered Aug 08 '20 at 09:54

You can add new layer called DTO, and using famous library modelmapper

Add this in your pom.xml

<dependency>
    <groupId>org.modelmapper</groupId>
    <artifactId>modelmapper</artifactId>
    <version>2.3.5</version>
</dependency>

Create bean to use modelmapper in your application main for example

@Bean
public ModelMapper modelMapper() {
    return new ModelMapper();
}

And then create class UserDto example

public class UserDto { 
 private Long id;
    String username;
    // standard getters and setters

    private UserDto convertToDto(User user) {
        UserDto userDto = modelMapper.map(user, UserDto);
        return userDto;
    }

}

In your controller or service

return convertToDto(userRepository.findById(id)); // wil return userDto

Hope useful.

score 1 · Accepted Answer · answered Aug 08 '20 at 10:37

1

Use @get:JsonIgnore on the field to skip serialization of that in response.

Obviously you don't need to send the password hash in the response. You need the password in service, it just ignored when giving serialize the response.

answered Aug 08 '20 at 10:37

Eklavya

17,618
4
28
57

I'm facing a problem. My `POST` request (to add user) is failing because the password field is being ignored in case of saving data too. – krtkush Aug 11 '20 at 13:58
1

[This](https://stackoverflow.com/questions/12505141/only-using-jsonignore-during-serialization-but-not-deserialization) works. – krtkush Aug 11 '20 at 14:03

How to ignore certain column from being fetched when using findBy.. in JPA

2 Answers2