Why Doesn't jpa add data to the foreign key value

Question

I have a users table which contains the user details. i also have a authorities table which has the role of a user. The user and authorities table has one to many mapping. When i try to save the details using Jpa the foreign key column is blank no data is inserted in that field. i have a form in which i am specifying the role of the user along with other details.

package com.example.StarsProject.Model;

import lombok.Getter;
import lombok.Setter;

import javax.persistence.*;

@Entity
@Table
@Getter
@Setter
public class Authorities {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;
    private String role;
    @ManyToOne(cascade = CascadeType.PERSIST,fetch=FetchType.EAGER)
    @JoinColumn(name = "users_id", referencedColumnName = "id")
    private Users users;

    public Authorities(String role){
        this.role = role;
    }

}

package com.example.StarsProject.Model;

import com.example.StarsProject.DTO.UserDTO;
import lombok.Getter;
import lombok.Setter;

import javax.persistence.*;
import java.util.Arrays;
import java.util.HashSet;
import java.util.Set;

@Entity
@Table
@Getter
@Setter
public class Users {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;
    @Column(name = "first_name")
    private String firstname;
    @Column(name = "last_name")
    private String lastname;
    @Column(unique = true)
    private String email;
    private String password;
    @OneToMany(fetch = FetchType.EAGER,targetEntity = Authorities.class,mappedBy = "users", cascade = CascadeType.PERSIST)
    private  Set<Authorities> authorities;

    public Users(UserDTO userDTO) {
        this.email = userDTO.getEmail();
        this.firstname = userDTO.getFirstname();
        this.lastname = userDTO.getLastname();
        this.password = userDTO.getPassword();
//        Authorities authorities = new Authorities();
//        authorities.setRole(userDTO.getRole());
//        Set<Authorities> set = new HashSet<>();
//        set.add(authorities);
        this.authorities = new HashSet<Authorities>(Arrays.asList(new Authorities(userDTO.getRole())));
    }

}

package com.example.StarsProject.Service;

import com.example.StarsProject.DTO.UserDTO;
import com.example.StarsProject.Model.Users;
import com.example.StarsProject.Repository.UserRepository;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class UserDetailsServiceImpl implements UserDetailsServiceInterface{

    @Autowired
    UserRepository userRepository;

    @Override
    public void storeUserDetails(UserDTO userDTO) {
        Users users = new Users(userDTO);
        userRepository.save(users);
    }
}

When i try to save the user details it doesn't insert any value in the foreign key column. Can someone tell me what i am doing wrong.

Read this https://stackoverflow.com/questions/3927091/save-child-objects-automatically-using-jpa-hibernate — JLazar0, Aug 04 '20 at 10:47
Does this answer your question? [hibernate and mappedBy: Is it possible to automatically set foreign key without setting bidirectional relationship among objects?](https://stackoverflow.com/questions/48817280/hibernate-and-mappedby-is-it-possible-to-automatically-set-foreign-key-without) — talex, Aug 04 '20 at 11:13
No, I have already added mappedBy in the Users table to indicate the mapping. But still it doesn't add the data/ — AMITH SAI, Aug 04 '20 at 11:34

score 0 · Answer 1 · answered Aug 04 '20 at 11:11

0

You need to setusers field in Authorities manually. Hibernate won't fill it for you.

answered Aug 04 '20 at 11:11

talex

17,973
3
29
66

Why Doesn't jpa add data to the foreign key value

1 Answers1