[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4987) SecondaryTable JoinColumn cannot reference a non primary key
Michel Domenjoud (JIRA)
noreply at atlassian.com
Thu Dec 23 08:19:05 EST 2010
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4987?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=39422#action_39422 ]
Michel Domenjoud commented on HHH-4987:
---------------------------------------
I just tested it on an existing DB with the whole schema already created and I obtained the same exception.
> SecondaryTable JoinColumn cannot reference a non primary key
> ------------------------------------------------------------
>
> Key: HHH-4987
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4987
> Project: Hibernate Core
> Issue Type: Bug
> Environment: Hibernate libraries added to jboss-6.0.0.20100216-M2(3.5) and jboss-5.1.0.GA(3.3.1) used with postgresql-8.3.7-1 database and jdbc driver postgresql-8.3-603.jdbc4.jar
> Reporter: Krashan Brahmanjara
>
> Hibertate annotations reject correct annotations with an error
> Full exception
> org.hibernate.AnnotationException: SecondaryTable JoinColumn cannot reference a non primary key
> at org.hibernate.cfg.annotations.TableBinder.bindFk(TableBinder.java:243)
> at org.hibernate.cfg.annotations.EntityBinder.bindJoinToPersistentClass(EntityBinder.java:520)
> at org.hibernate.cfg.annotations.EntityBinder.createPrimaryColumnsToSecondaryTable(EntityBinder.java:510)
> at org.hibernate.cfg.annotations.EntityBinder.finalSecondaryTableBinding(EntityBinder.java:441)
> at org.hibernate.cfg.SecondaryTableSecondPass.doSecondPass(SecondaryTableSecondPass.java:25)
> Example
> Three entity, two connected to main 'dokument' by their id columns
> @Entity
> @Table(name = "dokument")
> @SecondaryTables(value = {
> @SecondaryTable(name = "dokument_status", pkJoinColumns = @PrimaryKeyJoinColumn(name = "id_status", referencedColumnName = "id_status")),
> @SecondaryTable(name = "typ_dok", pkJoinColumns = @PrimaryKeyJoinColumn(name = "id_type", referencedColumnName = "id_type")) })
> public class PosrDokument implements Serializable {
> @Id
> @Column(name="id_dokumentu", unique=true, nullable=false)
> private int id_dokumentu;
> @Column(name = "status", table = "dokument_status", nullable = false, insertable = false, updatable = false)
> private String status;
> @Column(name = "name", table = "typ_dok", nullable = false, insertable = false, updatable = false)
> private String name;
> (...)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the hibernate-issues
mailing list