[jboss-user] [EJB 3.0] - @SecondaryTable. How to use it?
How can I use @SecondaryTable?
I have a Contact entity which defines a person's email, phone etc. There may be
several of these pointing to a single Person entity.
Because a person may belong to several organizations, and have several contactable
personas.
So. I want to create a ContactPerson entity from two tables.
It seems that I have to have the primary table as the Person table because there are many
Contacts, and they have a foreign key which points to the Person's primary key, and it
only works this way round, the seconary pointing to the primary. You can't have a FK
on the primary pointing to the secondary!!!
But obviously, the @Id field cannot be the id field of that primary table, the Person
table. Because it will be repeated several times, once for each Contact that's linked
to it.
so I have
| @javax.persistence.Table(name="Person")
| @SecondaryTable(name="ContactDetails",
| pkJoinColumns=@PrimaryKeyJoinColumn(name="person_id"),
| uniqueConstraints = @UniqueConstraint(columnNames={"person_id",
"player_id"})
| )
| public class ContactPerson extends CompositeEntity implements Serializable
| {
| private Long id;
| @Column(table="ContactDetails", name="id")
| @Id
| public Long getId() {
| return id;
| }
| public void setId(Long id) {
| this.id = id;
| }
| ...
|
And I think it's that ID that's causing the problem.
With this, I get
| org.hibernate.MappingException: Unable to find logical column name from physical name
id in table person
| org.hibernate.cfg.Mappings.getLogicalColumnName(Mappings.java:514)
|
org.hibernate.cfg.Ejb3JoinColumn.linkValueUsingDefaultColumnNaming(Ejb3JoinColumn.java:270)
| org.hibernate.cfg.annotations.TableBinder.bindFk(TableBinder.java:214)
|
org.hibernate.cfg.annotations.CollectionBinder.bindCollectionSecondPass(CollectionBinder.java:1253)
|
org.hibernate.cfg.annotations.CollectionBinder.bindManyToManySecondPass(CollectionBinder.java:1101)
|
org.hibernate.cfg.annotations.CollectionBinder.bindStarToManySecondPass(CollectionBinder.java:567)
|
org.hibernate.cfg.annotations.CollectionBinder$1.secondPass(CollectionBinder.java:508)
| org.hibernate.cfg.CollectionSecondPass.doSecondPass(CollectionSecondPass.java:43)
| org.hibernate.cfg.Configuration.secondPassCompile(Configuration.java:1130)
|
org.hibernate.cfg.AnnotationConfiguration.secondPassCompile(AnnotationConfiguration.java:296)
| org.hibernate.cfg.Configuration.buildMappings(Configuration.java:1115)
| org.hibernate.ejb.Ejb3Configuration.buildMappings(Ejb3Configuration.java:1233)
|
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4054833#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...