我是初学者用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依赖)任何人都可以告诉我什么是我的错误或者可以解决这个问题.谢谢.