Table Column Mapping error on Hibernate with spring boot

Question

I have two table on MySql database. Item, ItemGroup which are related by Item.groupid -> ItemGroup.id I am also using hibernate-entitymanager and spring boot. Here are my entity classes for Item and ItemGroup.

Item.java

package com.thiha.entities;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;

@Entity
public class Item {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Integer id;
    private String createdDate;
    private String modifiedDate;
    private String itemCode;
    private String description;
    private int groupId;
    private double quantity;
    private double price;
    private int recordStatus;
    private ItemGroup itemGroup;

    @ManyToOne
    @JoinColumn(name = "groupid")
    public ItemGroup getItemGroup() {
        return itemGroup;
    }

    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id = id;
    }
    public String getCreatedDate() {
        return createdDate;
    }
    public void setCreatedDate(String createdDate) {
        this.createdDate = createdDate;
    }
    public String getModifiedDate() {
        return modifiedDate;
    }
    public void setModifiedDate(String modifiedDate) {
        this.modifiedDate = modifiedDate;
    }
    public String getItemCode() {
        return itemCode;
    }
    public void setItemCode(String itemCode) {
        this.itemCode = itemCode;
    }
    public String getDescription() {
        return description;
    }
    public void setDescription(String description) {
        this.description = description;
    }
    public int getGroupId() {
        return groupId;
    }
    public void setGroupId(int groupId) {
        this.groupId = groupId;
    }
    public double getQuantity() {
        return quantity;
    }
    public void setQuantity(double quantity) {
        this.quantity = quantity;
    }
    public double getPrice() {
        return price;
    }
    public void setPrice(double price) {
        this.price = price;
    }
    public int getRecordStatus() {
        return recordStatus;
    }
    public void setRecordStatus(int recordStatus) {
        this.recordStatus = recordStatus;
    }
}

ItemGroup.java

package com.thiha.entities;

import java.util.List;
import javax.persistence.CascadeType;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.OneToMany;

@Entity
public class ItemGroup {

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Integer id;
    private String createdDate;
    private String modifiedDate;
    private String groupCode;
    private String groupName;
    private int recordStatus;
    private List<Item> items;

    @OneToMany(mappedBy = "itemGroup", cascade = CascadeType.ALL)
    public List<Item> getItems(){
        return items;
    }

    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id = id;
    }
    public String getCreatedDate() {
        return createdDate;
    }
    public void setCreatedDate(String createdDate) {
        this.createdDate = createdDate;
    }
    public String getModifiedDate() {
        return modifiedDate;
    }
    public void setModifiedDate(String modifiedDate) {
        this.modifiedDate = modifiedDate;
    }
    public String getGroupCode() {
        return groupCode;
    }
    public void setGroupCode(String groupCode) {
        this.groupCode = groupCode;
    }
    public String getGroupName() {
        return groupName;
    }
    public void setGroupName(String groupName) {
        this.groupName = groupName;
    }
    public int getRecordStatus() {
        return recordStatus;
    }
    public void setRecordStatus(int recordStatus) {
        this.recordStatus = recordStatus;
    }
}

I also create a foreign keys in Item table reference to ItemGroup table with foreign key groupid. But when I run the code with mvn spring-boot:run, I got some exception as following:

org.hibernate.MappingException: Could not determine type for: java.util.List, at table: item_group, for columns: [org.hibernate.mapping.Column(items)]
at org.hibernate.mapping.SimpleValue.getType(SimpleValue.java:431)
at org.hibernate.mapping.SimpleValue.isValid(SimpleValue.java:398)
at org.hibernate.mapping.Property.isValid(Property.java:225)
at org.hibernate.mapping.PersistentClass.validate(PersistentClass.java:595)
at org.hibernate.mapping.RootClass.validate(RootClass.java:265)
at org.hibernate.boot.internal.MetadataImpl.validate(MetadataImpl.java:329)
at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:443)
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:879)

If I remove the relationships in both class, it is working properly but I cannot make INNER JOIN query. Please help me to solve this problem

Answer 1

dont worry there is do only one thing remove your annotation of @Id and @generatorValue annotation above on the id and put on the getter method of your id the problem will be fix.....!

Answer 2

You can't mix annotation conventions in Hibernate. Please try to move your @Id and @GeneratedValue annotations to getter, or @OneToMany and @ManyToOne to fields.

Answer 3

It says

Could not determine type for: java.util.List, at table: item_group, for columns: [org.hibernate.mapping.Column(items)]'

Because your mappedBy is incorrect.

When you put annotation on getter getCategory(), hibernate understands that it's category.

@ManyToOne
@JoinColumn(name = "groupid")
public ItemGroup getCategory() {
    return itemGroup;
}

So, please use appropriate name in your class ItemGroup

@OneToMany(mappedBy = "category", cascade = CascadeType.ALL)
public List<Item> getItems(){
    return items;
}