Hibernate中的ManyToMany映射引用错误（api生成的表名）Table Spring Boot

Question

使用的技术有:Spring-boot、Spring-data-Jpa、Hibernate、MySql

完全错误为：

自定义视图实体是：

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

    /**
     * 
     */
    private static final long serialVersionUID = -7325379776348403853L;

    @Id
    @GenericGenerator(name="generator", strategy="increment")
    @GeneratedValue(generator="generator")
    @Column(name="custom_id")
    private Long customId;

    @Column(name="view_name")
    private String viewName;

    @ManyToOne
    @JoinColumn(name="user_id")
    private User user;

    @ManyToMany(cascade = {CascadeType.MERGE, CascadeType.REMOVE},fetch=FetchType.LAZY)
    @JoinTable(name = "productcolumn_customfields", 
        joinColumns = { @JoinColumn(name = "cv_id") },
        inverseJoinColumns = { @JoinColumn(name = "pcd_id",nullable = false, updatable = false) })
    private List<ProductColumnsDetailsCV> productColumnsDetails;

    public CustomViews(){
        super();
    }

    public CustomViews(Long customId, String viewName, User user, List<ProductColumnsDetailsCV> productColumnsDetails) {
        super();
        this.customId = customId;
        this.viewName = viewName;
        this.user = user;
        this.productColumnsDetails = productColumnsDetails;
    }

    /**
     * @return the customId
     */
    public Long getCustomId() {
        return customId;
    }

    /**
     * @param customId the customId to set
     */
    public void setCustomId(Long customId) {
        this.customId = customId;
    }

    /**
     * @return the viewName
     */
    public String getViewName() {
        return viewName;
    }

    /**
     * @param viewName the viewName to set
     */
    public void setViewName(String viewName) {
        this.viewName = viewName;
    }

    /**
     * @return the user
     */
    public User getUser() {
        return user;
    }

    /**
     * @param user the user to set
     */
    public void setUser(User user) {
        this.user = user;
    }

    /**
     * @return the productColumnsDetails
     */
    public List<ProductColumnsDetailsCV> getProductColumnsDetails() {
        return productColumnsDetails;
    }

    /**
     * @param productColumnsDetails the productColumnsDetails to set
     */
    public void setProductColumnsDetails(List<ProductColumnsDetailsCV> productColumnsDetails) {
        this.productColumnsDetails = productColumnsDetails;
    }

}

产品列详细信息实体：

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

    private static final long serialVersionUID = 7685428544522743567L;

    @Id
    @GenericGenerator(name="generator", strategy="increment")
    @GeneratedValue(generator="generator")
    @Column(name="pid")
    private Long pid;

    @Column(name="display_name")
    private String displayName;

    @Column(name="column_name")
    private String columnName;

    @Column(name="actual_name")
    private String actualName;

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

    @Column(name="is_pk")
    private boolean isPk;

    @Column(name="is_sortable")
    private boolean isSortable;

    @Column(name="order_")
    private int order;

    @Column(name="is_popup")
    private boolean isPopUp;


    @ManyToMany(cascade = {CascadeType.MERGE, CascadeType.REMOVE})
    @JoinColumn(name="productColumnsDetails")
    private List<CustomViews> customviews;


    public ProductColumnsDetailsCV() {
        super();
    }


    /**
     * @param pid
     * @param displayName
     * @param columnName
     * @param actualName
     * @param customFilter
     */
    public ProductColumnsDetailsCV(Long pid, String displayName, String columnName, String actualName) {

        this.pid = pid;
        this.displayName = displayName;
        this.columnName = columnName;
        this.actualName = actualName;
    }

    //Getters & Setter

}

表格：

CREATE TABLE `productcolumn_customfields` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `pcd_id` bigint(20) DEFAULT NULL,
  `cv_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id_pid_productcoldetails_idx` (`pcd_id`),
  KEY `id_cvid_customviews_idx` (`cv_id`),
  CONSTRAINT `fk_pcd_id_productcolumndet` FOREIGN KEY (`pcd_id`) REFERENCES `product_columns_details` (`pid`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `id_cvid_customviews` FOREIGN KEY (`cv_id`) REFERENCES `custom_views` (`custom_id`) ON DELETE CASCADE ON UPDATE CASCADE

CREATE TABLE `product_columns_details` (
  `pid` bigint(20) NOT NULL AUTO_INCREMENT,
  `display_name` varchar(255) DEFAULT NULL,
  `column_name` varchar(255) DEFAULT NULL,
  `actual_name` varchar(255) DEFAULT NULL,
  `type` varchar(25) NOT NULL DEFAULT 'String',
  `is_pk` bit(1) NOT NULL DEFAULT b'0',
  `is_sortable` bit(1) NOT NULL DEFAULT b'0',
  `order_` int(11) NOT NULL DEFAULT '0',
  `is_popup` bit(1) NOT NULL DEFAULT b'0',
  PRIMARY KEY (`pid`),
  UNIQUE KEY `actual_name_UNIQUE` (`actual_name`)

CREATE TABLE `custom_views` (
  `custom_id` bigint(30) NOT NULL AUTO_INCREMENT,
  `view_name` varchar(255) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  PRIMARY KEY (`custom_id`),
  KEY `custom_views_ibfk_1` (`user_id`),
  CONSTRAINT `custom_views_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user`enter code here`_id`) ON DELETE CASCADE ON UPDATE CASCADE
)

Answer 1

这里出现问题是因为双方（在实体中）执行hibernate来执行多对多映射，这是错误的。这是resson hibernate假设连接表名为product_columns_details_customviews（不存在），并且不从配置（在实体CUSTOMVIEWS的注释中）获取表名，即productcolumn_customfields

现有代码：

@Entity
@Table(name = "product_columns_details")
public class ProductColumnsDetailsCV implements Serializable{
...
...
...
@ManyToMany(cascade = {CascadeType.MERGE, CascadeType.REMOVE})
@JoinColumn(name="productColumnsDetails")
private List<CustomViews> customviews;

而且

@Entity
@Table(name = "custom_views")
public class CustomViews implements Serializable{
...
...
...
@ManyToMany(cascade = {CascadeType.MERGE, CascadeType.REMOVE},fetch=FetchType.LAZY)
@JoinTable(name = "productcolumn_customfields", 
    joinColumns = { @JoinColumn(name = "cv_id") },
    inverseJoinColumns = { @JoinColumn(name = "pcd_id",nullable = false, updatable = false) })
private List<ProductColumnsDetailsCV> productColumnsDetails;

@ManyToMany(cascade = {CascadeType.MERGE, CascadeType.REMOVE}, mappedBy = "productColumnsDetails")
private List<CustomViews> customviews;