Hibernate错误列名无效

Question

import java.io.Serializable;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToOne;
import javax.persistence.Table;

@Entity
@Table(name="Product")
public class Product implements Serializable{

    @Id
    @Column(name="productId")
    @GeneratedValue
    private Integer productId;

    @Column(name="productName")
    private String productName;

    @Column(name="productPrice")
    private int productPrice;


    //---------------------------------------item mapped to category------------------------------------------//
    @ManyToOne(cascade = CascadeType.ALL,fetch = FetchType.EAGER)
    @JoinTable(
            name="CategoryProduct",
            joinColumns= @JoinColumn(name="productId")
    )
    private Category category;
    //--------------------------------------------------------------------------------------------------------//



    public Integer getProductId() {
        return productId;
    }

    public void setProductId(Integer productId) {
        this.productId = productId;
    }

    public String getProductName() {
        return productName;
    }

    public void setProductName(String productName) {
        this.productName = productName;
    }

    public int getProductPrice() {
        return productPrice;
    }

    public void setProductPrice(int productPrice) {
        this.productPrice = productPrice;
    }

    public Category getCategory() {
        return category;
    }

    public void setCategory(Category category) {
        this.category = category;
    }




}

import java.util.Set;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.OneToMany;
import javax.persistence.Table;

import java.io.Serializable;
@Entity
@Table(name="Category")
public class Category implements Serializable{

    @Id
    @Column(name="categoryId")
    @GeneratedValue
    private Integer categoryId;

    @Column(name="categoryName")
    private String categoryName;

    @OneToMany(cascade=CascadeType.ALL,fetch=FetchType.EAGER)
    @JoinTable(
            name="CategoryProduct",
            joinColumns = @JoinColumn(name="categoryId"),
            inverseJoinColumns = @JoinColumn(name="productId")
    )
    public Set<Product> product;


    public Integer getCategoryId() {
        return categoryId;
    }

    public void setCategoryId(Integer categoryId) {
        this.categoryId = categoryId;
    }

    public String getCategoryName() {
        return categoryName;
    }

    public void setCategoryName(String categoryName) {
        this.categoryName = categoryName;
    }

    public Set<Product> getProduct() {
        return product;
    }

    public void setProduct(Set<Product> product) {
        this.product = product;
    }

}

我的表的结构Product的列为productId，poductName和productPrice类别的列为categoryId，categoryName和categoryproducts的列为categoryId和productId

Answer 1

您忘记将inversejoincolumns放在@jointable in Product类中。这导致hibernate使用它们的可联合约定，即 _ 。将其更改为

@JoinTable(
    name="CategoryProduct",
    joinColumns = @JoinColumn(name="productId"),
    inverseJoinColumns = @JoinColumn(name="categoryId")
)
private Category category;

然而，从你的设计来看，你实际上是在产品和类别之间建立了2个单向的关联。如果您想创建双向关联，我建议您更改一侧（类别），使用mappedBy

@OneToMany(mappedBy="category", cascade=CascadeType.ALL,fetch=FetchType.EAGER)
public Set<Product> product;

它一般会达到同样的结果。希望有帮助！