Basically, I am trying to establish a
relationship between my two tables using spring boots. And the relationship which I had used was the
@onetoone and
@onetomany relationship. But after building the relationship and creating the table in MySQL whenever I run the programme my
foreign key is not updating. The relationship is one user can have many contacts. I have tried unidirectional as well as bidirectional mapping but it is not working.
I want in contact table there will be a separate column for the foreign key. Based on that key I will show all contacts for that particular user.
What I have tried:
This is my contact entity...
@Entity
@Table(name = "Contact")
public class ContactEntities {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private int c_id;
private String c_name;
private String second_c_name;
private String c_work;
private String c_emali;
private String c_phone;
private String c_image;
@Column(length = 5000)
private String c_description;
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "contact_id")
private UserEntities userEntities;
this is my user entity...
@Entity
@Table(name = "UserEntities")
public class UserEntities {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private int userId;
@NotBlank
@Size(min = 2, max = 20)
private String userName;
@NotBlank
@Column(unique = true)
@Email(regexp = "^[a-zA-Z0-9.!#$%&'*+/=?^_`{|}~-]+@[a-zA-Z0-9-]+(?:\\.[a-zA-Z0-9-]+)*$")
private String userEmail;
@NotNull(message = "password should not be blank")
private String userPass;
private boolean enable;
private String role;
@Column(length = 500)
private String userAbout;
@OneToMany(fetch = FetchType.LAZY, cascade = CascadeType.ALL, mappedBy = "userEntities")
private List<ContactEntities> contactList = new ArrayList<>();