Hibernate OneToOne Mapping Issue

Question

i have three entities as below:

1. Property
2. Property_Document
3. Property_User

Property and Property_Document have a One to Many relationship.
Property and Property_User has One to One relationship.

At the database level, Property_User has foreign key "property_id", back to the Property table.

I am using annotations to define the mappings and relationships between the entities.

Property.java

public class Property {
    //.....
    @OneToMany(cascade=CascadeType.ALL)
    @JoinColumn(name="property_id")
    private List<PropertyDocuments> docs;

    @OneToOne(cascade=CascadeType.ALL)
    private PropertyUser owner;
    //....
}

PropertyUser.java

public class PropertyUser {
    @Id
    private int id;

    @column
    private String name;
    //......
}

When it fetches the property, document list fetches successfully but when it tries to fetch the user information it shows below error message.

column: owner_id doesn't exist.

Please help. Thanks.

Answer 1

You need a column in the "property" table to hold the ID of the User it references. Since you didn't specify any column in your mapping, Hibernate uses the default column name, which is owner_id (the name of the property followed by the name of the column it references). If you want to use another column name, you have to tell Hibernate: it can't guess it magically:

@OneToOne(cascade=CascadeType.ALL)
@JoinColumn(name = "the_column_containing_the_id_of_the_referenced_user")
private PropertyUser owner;