Hibernate Create OneToMany instead of OneToOne

user_13746236 0
Viewed 107

I don't understand why this code create OneToMany instead of OneToOne Can somebody tell where i made mistake. I have got 2 class:

@Entity
@Table(name = "user")
public class User {

@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
@Column(unique=true)
@Id
private String login;
private String password;
private String firstName;
private String lastName;
private String city;
private int age;
private Sex sex ;
@OneToOne(fetch = FetchType.LAZY, mappedBy = "user", cascade = CascadeType.ALL)
//@JoinColumn(name= "user_details")
private UserProfile userProfile;

Second class:

@Entity
@Table(name = "user_profile")
public class UserProfile {

    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long Id;
    @Id
    private String user_login;
    private String user_interestings;
    @OneToOne//mappedBy= "userProfile")
    @MapsId
    private User user;

Here is image, how it end in MySQLWOrkbench enter image description here

Thanks for help.

one-to-one one-to-many jpa hibernate
1 Answers

Use @JoinColumn with the foreign key in UserProfile as your Database design

public class UserProfile {
    ...
    @OneToOne
    @JoinColumn(name = "user_login")
    private User user;
}

And your primary key for both table confusing. If you need both table use same primary key then map this way. Here both table primary key is id. You don't need user_login column then in UserProfile table.

public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    ...
    @OneToOne(fetch = FetchType.LAZY, mappedBy = "user", cascade = CascadeType.ALL)
    private UserProfile userProfile;
}

public class UserProfile {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long Id;
    ...
    @OneToOne
    @MapsId
    private User user;
}
user_42073060
Related