Spring Jpa - Query Result To Pojo

Spring Jpa Query Result To Pojo

//first prepare pojo for query

@JsonInclude(JsonInclude.Include.NON_NULL)
public class UserResponseVM implements Serializable{

    @JsonProperty("_id")
    private UUID id;
    private String name;
    
    .
    .
    .
    

//in repository we have below query that have two columns in result

@Query("select u.id, u.name from User u")
    List<Object[]> c();
    
    
//in service layer execute repository query and map it to the UserResponseVM 

    public List<UserResponseVM> findUserIdAndNameOfUsers() {
        List<UserResponseVM> userResponseVMList = queryResultMapper.mapResultToUserResponseVM(userRepository.findUserUuidAndVersionOfUsers());
        return userResponseVMList;
    }
    
//our mapper

public List<UserResponseVM> mapResultToUserResponseVM(List<Object[]> result){
        List<UserResponseVM> userResponseVMList = new ArrayList<>();
        for(Object[] object: result){
            UserResponseVM userResponseVM = new UserResponseVM();
            userResponseVM.setId((UUID) object[0]);
            userResponseVM.setName((Integer) object[1]);
            userResponseVMList.add(userResponseVM);
        }
        return userResponseVMList;
    }