[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: Repeated column in mapping for entity

[smix007]

Hello Stephen, 
I' m hitting the same exact problem; 
here my code:
TermProjPK.java
@Embeddable
  | public class TermProjPK implements Serializable {
  | private String auiw;
  | @Column(name = "AUIS", nullable = false)
  | private String auis;
  | 
TermProj.java

  | public class TermProj implements Serializable {
  | @EmbeddedId
  |     private TermProjPK termProjPK;
  | //jointure avec la table TermSource
  |     @ManyToOne
  |     @JoinColumn (name = "AUIW")
  |     private TermSource  auiw;  
  |     public TermSource getAuiw() {
  |         return auiw;
  |     }
  | 
  |     public void setAuiw(TermSource auiw) {
  |         this.auiw = auiw;
  |     }    
  |     
  |     
  |     //jointure avec la table SnomedInter   
  |     @ManyToOne 
  |     @JoinColumn (name = "AUIS")
  |     private SnomedInter auis;
  |     public SnomedInter getAuis() {
  |         return auis;
  |     }
  | 
  |     public void setAuis(SnomedInter auis) {
  |         this.auis = auis;
  |     }
  | @Column(name = "MODIF")
  |     private String modif;
  | 
  |     @Column(name = "SRC", nullable = false)
  |     private String src;
TermSource.java
public class TermSource implements Serializable {
  |  @Id
  |     @Column(name = "AUIW", nullable = false)
  |     private String auiw;
  | @OneToMany(mappedBy="auiw")
  |     private Collection<TermProj> termProjs;
  |     
  |      public Collection<TermProj> getTermProjs() {
  |         return termProjs;
  |     }
  | 
  |     public void setTermProjs(Collection<TermProj> termProjs) {
  |         this.termProjs = termProjs;
  |     }
SnomedInter.javapublic class SnomedInter implements Serializable {
  | @Id
  |     @Column(name = "AUIS", nullable = false)
  |     private String auis;
  | @OneToMany(mappedBy="auis")
  |     private Collection<TermProj> termProjs;
  |     
  |     public Collection<TermProj> getTermProjs() {
  |         return termProjs;
  |     }
  | 
  |     public void setTermProjs(Collection<TermProj> termProjs) {
  |         this.termProjs = termProjs;
  |     }
  | 
I always have the same error:
WARN  [ServiceController] Problem starting service persistence.units:ear=Pharmacovigilance.ear,jar=Pharmacovigilance-ejb.jar,unitName=Pharmacovigilance-ejbPU
  | org.hibernate.MappingException: Repeated column in mapping for entity: ejb.entity.TermProj column: AUIS (should be mapped with insert="false" update="false")
  |         at org.hibernate.mapping.PersistentClass.checkColumnDuplication(PersistentClass.java:575)
  | 
my servlet of tests is as follows:
 [...]TermProjFacadeLocal termProjFacadeLocal = (TermProjFacadeLocal) lookupTermProjFacade();
  |         
  |        
  |         
  |         List news = termProjFacadeLocal.findAll();
  |             
  | 
  |         out.println("<TABLE align=\"center\" frame=\"border\" cellpadding=\"2\">");
  |         out.println("<TR style=\"color:blue\"> <TH align=\"center\" > AUIW </TH> <TH align=\"center\"> AUIS </TH> <TH align=\"center\"> MODIF </TH><TH align=\"center\"> SRC </TH></TR>");
  |         for (Iterator it = news.iterator(); it.hasNext();) {
  |             TermProj elem = (TermProj) it.next();            
  |            out.println(" <TR> <TD> <b>" + elem.getTermProjPK().getAuiw() + " </b> </TD>");
  |            out.println("  <TD> <b>" + elem.getTermProjPK().getAuis() + " </b> </TD> ");            
  |             out.println("  <TD> <b>" + elem.getModif() + " </b> </TD> "); 
  |             out.println(" <TD> <b>" + elem.getSrc() + " </b> </TD> </TR>"); 
  |         }
  |         out.println("</TABLE>");
  | [...]
  |         
were there any suggestions made? Any help is greatly appreciated :) 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3994933#3994933

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3994933