全球最大的购物网站,工程交易服务主页,wordpress页面和分类目录,建站之星安装教程前些天发现了一个巨牛的人工智能学习网站#xff0c;通俗易懂#xff0c;风趣幽默#xff0c;忍不住分享一下给大家。点击跳转到教程。
报错如题#xff1a;
Caused by: org.hibernate.DuplicateMappingException: Table [xxx] contains physical column name [comment] …前些天发现了一个巨牛的人工智能学习网站通俗易懂风趣幽默忍不住分享一下给大家。点击跳转到教程。
报错如题
Caused by: org.hibernate.DuplicateMappingException: Table [xxx] contains physical column name [comment] referred to by multiple physical column names: [comment], [auditComment]at org.hibernate.boot.internal.InFlightMetadataCollectorImpl$TableColumnNameBinding.bindPhysicalToLogical(InFlightMetadataCollectorImpl.java:922)at org.hibernate.boot.internal.InFlightMetadataCollectorImpl$TableColumnNameBinding.addBinding(InFlightMetadataCollectorImpl.java:891)at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.addColumnNameBinding(InFlightMetadataCollectorImpl.java:961)at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.addColumnNameBinding(InFlightMetadataCollectorImpl.java:942)at ... ... 情况1. 项目用的 spring-data-jpa 。
原本对于表和本类的每个字段都有给注解 Colum 来对应其实不用给也可以。把这些注解注释掉工程就可以正常启动了。
如下 import org.codehaus.jackson.annotate.JsonIgnore;
import org.codehaus.jackson.annotate.JsonIgnoreProperties;
import org.codehaus.jackson.map.annotate.JsonSerialize;import javax.persistence.*;
import java.io.Serializable;
import java.util.Date;/*** 解冻申请*/
Entity(name unfreeze)
Table(name unfreeze_apply)
JsonIgnoreProperties(ignoreUnknown true)
public class UnfreezeApply implements Serializable {private static final long serialVersionUID -1826761763082698565L;IdGeneratedValue(strategy GenerationType.AUTO)private Integer id;// Column(name employee_no, nullable false)private String employeeNo;Transientprivate String employeeName; //员工名称ManyToOne(fetch FetchType.EAGER)JsonIgnore
// JoinColumn(nameemployee_no, referencedColumnNameusernumber, insertablefalse, updatablefalse)private User employee;// Column(name reason, nullable false)private String reason;}
启动成功 情况2. 网上的其它情况 当有一个物理表映射两个或多个逻辑表名称时会发生此异常。如 因为那里有多个JoinColumns使用相同的列名user_id
为每个JoinColumns在注释中的name参数中定义设置一个不同的名称
OneToOne
JoinColumn(name local_user_id)
public User getUser() {return user;
}OneToOne
JoinColumns({JoinColumn(name userId, referencedColumnName userId),JoinColumn(name providerId, referencedColumnName providerId),JoinColumn(name providerUserId, referencedColumnName providerUserId)}
)
public UserConnection getUserConnection() {return userConnection;
} 参考http://mussatto.github.io/java/hibernate/error/fix/mapping/2016/11/14/hibernate-error-multiple-physical-columns.html
