[hibernate-issues] [Hibernate-JIRA] Commented: (ANN-509) referencedColumnName to non primary key foreign key column causes MappingException

[ http://opensource.atlassian.com/projects/hibernate/browse/ANN-509?page=co... ] harry clark commented on ANN-509: --------------------------------- Unfortunately i think this problem is still with us, I have ~1360 persistent classes, using ~1100 compound key classes. I get the exception cited above Exception in thread "main" java.lang.ExceptionInInitializerError at com.kve.util.HibernateUtil.<clinit>(HibernateUtil.java:1360) at com.kve.main.Main.main(Main.java:22) Caused by: org.hibernate.MappingException: Unable to find column with logical name: SRZPT3 in org.hibernate.mapping.Table(D4TGCPP) and its related supertables and secondary tables The relation in question is one to many. D4TGCPP has a one to many to the table in which SRZPT3 is a key. The mapping is @OneToMany(targetEntity=GT_EdfReleaseSeqPci.class) @JoinColumns({ @JoinColumn(name="TGZPT3",referencedColumnName="SRZPT3"), @JoinColumn(name="TGGBC5",referencedColumnName="SRGBC5"), @JoinColumn(name="TGCCS5",referencedColumnName="SRCCS5"), @JoinColumn(name="TGCDS5",referencedColumnName="SRCDS5"), @JoinColumn(name="TGB3N4",referencedColumnName="SRB3N4"), @JoinColumn(name="TGWON4",referencedColumnName="SRWON4"), @JoinColumn(name="TGWIN4",referencedColumnName="SRWIN4") }) public Set<GT_EdfReleaseSeqPci> gt_EdfReleaseSeqPci; The mapped table has 8 keys; the one to many uses 7 of them, and they are correct. When I move the enclosing table to be first in the configuration the same exception happens on a different, unrelated table. The enclosing table (D4TGCPP, named in the exception) is GT_EdfReleaseSeqPac; the one to many is below it in collating order, GT_EdfReleaseSeqPci, not above it. The exc msg sort of implies that the join col is missing on the enclosing table, but that table is used is only one other mapping (one to many, as target). The mapping shown here is the only one contained in that table. I can't imagine a simple example with this database, or on this server, for admin reasons. I'll see what else I can do; perhaps this gives someone ideas. Thanks -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira