Order of @JoinColumn annotations
--------------------------------
Key: HCANN-31
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HCANN-31
Project: Hibernate Commons Annotations
Issue Type: Bug
Reporter: Rich McLaughlin
I have two entities that I'm trying to join on 3 columns. For some reason, the order
of the @JoinColumn annotations affects the SQL that get produced. I double-check my
classes and all the columns are named and annotated correctly.
This annotation:
@JoinColumns({
@JoinColumn (name = "ATTR_1"),
@JoinColumn (name = "ATTR_2"),
@JoinColumn (name = "ATTR_3")
})
produces this SQL:
on this_.ATTR_1=othertable_.ATTR_2
and this_.ATTR_2=othertable_.ATTR_1
and this_.ATTR_3=othertable_.ATTR_3
But when I switch the annotation:
@JoinColumns({
@JoinColumn (name = "ATTR_2"),
@JoinColumn (name = "ATTR_1"),
@JoinColumn (name = "ATTR_3")
})
Then it works
on this_.ATTR_1=othertable_.ATTR_1
and this_.ATTR_2=othertable_.ATTR_2
and this_.ATTR_3=othertable_.ATTR_3
Any 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