Dear Members
I am working with the follow dependencies
Among many entities I have these two Asignado and TraspasoAsignadoCode:<dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-core</artifactId> <version>3.3.2.GA</version> </dependency> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-annotations</artifactId> <version>3.3.1.GA</version> </dependency> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-commons-annotations</artifactId> <version>3.3.0.ga</version> </dependency> <dependency> <groupId>javassist</groupId> <artifactId>javassist</artifactId> <version>3.6.0.GA</version> </dependency>
The first defined in this way
The SecondCode:@Entity @Table(name="asignado") public class Asignado implements Serializable{ private static final long serialVersionUID = 1L; private String idAsignado; .... public Asignado(){} @Id public String getIdAsignado() { return idAsignado; } public void setIdAsignado(String idAsignado) { this.idAsignado = idAsignado; }
I get this errorCode:@Entity @Table(name="traspasoasignado") public class TraspasoAsignado implements Serializable{ private static final long serialVersionUID = 1L; .... @Id public String getIdTraspasoAsignado() { return idTraspasoAsignado; } ... @OneToOne @JoinColumn(name="idAsignado") public Asignado getAsignadoOrigen() { return asignadoOrigen; } public void setAsignadoOrigen(Asignado asignadoOrigen) { this.asignadoOrigen = asignadoOrigen; } @OneToOne @JoinColumn(name="idAsignado") public Asignado getAsignadoDestino() { return asignadoDestino; } public void setAsignadoDestino(Asignado asignadoDestino) { this.asignadoDestino = asignadoDestino; }
OK, is clear that idAsignado is repeteadCode:Caused by: org.hibernate.MappingException: Repeated column in mapping for entity: com.jordan.manuel.domain.TraspasoAsignado column: idAsignado (should be mapped with insert="false" update="false")
I already did a research on the forum and the most common solution is do
but I did realize the followCode:@JoinColumn(name="idAsignado", insertable=false, updatable=false)
Even if I use insertable=false and updatable=false I will have one column that you could not write to or update to; if that so, then, when hibernate it's retrieving the data how it will know which property to fill, with only one column for 2 properties.
edited from here (last reply)
I want get the follow row representation
Asignado
PK
Asg1 ...
Asg2 ...
Asg3 ...
TraspasoAsignado
PK
Tr1 .. Asg1 Asg2 ...
Tr2 .. Asg10 Asg22 ...
Tr3 .. Asg15 Asg50 ...
Obviously each FK value for idAsignado in TraspasoAsignado entity never must be the same
How I could resolve this?
Thanks in advanced


Reply With Quote