java映射重复写,java – 引起：org.hibernate.MappingException：实体映射中的重复列

我是初学者用maven和JBOSS处理JPA,用Restful来制作我的应用程序我有以下问题我做了DEPLOY

Caused by: javax.persistence.PersistenceException: [PersistenceUnit: com.company.test_resources_war_1.0-SNAPSHOTPU] Unable to build EntityManagerFactory

Caused by: org.hibernate.MappingException: Repeated column in mapping for entity: database.Photo column: fid_module (should be mapped with insert = \ "false \" update = \ "false \") "}}

不是那一步,检查所有的posles解决方案,但没有找到任何东西,有人可以帮助我？

提前致谢

下面我展示了我拥有的postgres中的SQL代码,并进行了映射.

我有三个表(活动,事件和照片),其中一个(照片)引用另外两个(活动和事件),但在一个列(photo.fid_module)

SQL代码(enginer数据库 – > Postgresql)：

CREATE TABLE activity (

id_activity integer not null,

name character varying(150),

description text,

CONSTRAINT id_activity_pk PRIMARY KEY (id_activity)

)

CREATE TABLE event (

id_event integer not null,

name character varying(150),

description text,

date timestamp without time zone,

CONSTRAINT id_event_pk PRIMARY KEY (id_event)

)

CREATE TABLE photo(

id_photo integer not null,

path character varying(150),

fid_module integer not null,

CONSTRAINT id_photo_pk PRIMARY KEY (id_photo),

CONSTRAINT fk_photo_activity FOREIGN KEY (fid_module)

REFERENCE activity (id_activity) MATCH SIMPLE

ON UPDATE NO ACTION ON DELETE NO ACTION,

CONSTRAINT fk_photo_event FOREIGN KEY (fid_module)

REFERENCE event (id_event) MATCH SIMPLE

ON UPDATE NO ACTION ON DELETE NO ACTION

)

现在我在Netbenas的帮助下做了映射并给了我以下代码(我为三个表做了映射,但是在向我展示问题是在Photo.java类中).

@Entity

@Table(name = "photo")

@XmlRootElement

@NamedQueries({

@NamedQuery(name = "photo.findAll", query = "SELECT p FROM Photo p"),

@NamedQuery(name = "photo.findByFidPhoto", query = "SELECT p FROM Photo p WHERE p.fidphoto = :fidphoto"),

@NamedQuery(name = "photo.findByIdPhoto", query = "SELECT p FROM Photo p WHERE p.idphoto = :idphoto")})

public class Photo implements Serializable {

private static final long serialVersionUID = 1L;

@Id

@GeneratedValue(strategy = GenerationType.IDENTITY)

@Basic(optional = false)

@Column(name = "id_photo")

private Integer idPhoto;

@Column(name = "path")

private Recurso fidPath;

@JoinColumn(name = "fid_module", referencedColumnName = "id_activity")

@ManyToOne(optional = false, fetch = FetchType.LAZY)

private SliderWebHome fidModule;

@JoinColumn(name = "fid_module", referencedColumnName = "id_event")

@ManyToOne(optional = false, fetch = FetchType.LAZY)

private Publicacion fidModule1;

public ModuloRecurso() {

}

.......

}

我正在使用JPA进行持久化(但是做mvn clean install和mvn jboss-as：部署几个拉我hibernate依赖)任何人都可以告诉我什么是我的错误或者可以解决这个问题.谢谢.

解决方法:

如另一个答案所述,您的Java代码为两个字段指定了相同的连接列名称,这两个字段无法正常工作.

如果这个Java代码是由netbeans映射工具生成的,就像你的笔记中所看到的那样

Now the mapping I did with the help of Netbenas and gave me the following code …

糟糕的Java映射可能是由SQL中的约束组合错误引起的.

您在照片表的定义中有：

CONSTRAINT fk_photo_activity FOREIGN KEY (fid_module)

REFERENCE activity (id_activity) MATCH SIMPLE

ON UPDATE NO ACTION ON DELETE NO ACTION,

CONSTRAINT fk_photo_event FOREIGN KEY (fid_module)

REFERENCE event (id_event) MATCH SIMPLE

ON UPDATE NO ACTION ON DELETE NO ACTION

它试图使列fid_module成为外键引用活动,也是外键引用事件,这是无效的.

如果您需要从照片到这两个表的外键,则需要使用两个不同的列.

标签：java,postgresql,maven,jpa,hibernate

来源： https://codeday.me/bug/20191007/1869057.html