[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3824) OneToOne join by Non-primary key column throws PropertyAccessException when join column is String
Vladimir V (JIRA)
noreply at atlassian.com
Sat Dec 4 18:33:14 EST 2010
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=39294#action_39294 ]
Vladimir V commented on HHH-3824:
---------------------------------
hibernate distribution 3.6.0.Final
Issue still here.
Ignores "referencedColumnName" and always try`s to fetch using primary key;
@Entity
@DiscriminatorValue("3")
//@Table InformingLinks
public class InformingLink_z extends InformingLink {}
@Entity
public class Informing {
@OneToOne(cascade = CascadeType.ALL,fetch = FetchType.EAGER)
@JoinColumn(name="n",referencedColumnName = "n1")
InformingLink_z informingLink;
}
createQuery("from Informing o left outer join fetch o.informingLink")
generates
"select * from Informing i left outer join InformingLinks il on i.n=il.n" must be "=il.n1 and DiscriminatorValue=3"
same error for
createQuery("from Informing")
> OneToOne join by Non-primary key column throws PropertyAccessException when join column is String
> -------------------------------------------------------------------------------------------------
>
> Key: HHH-3824
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3824
> Project: Hibernate Core
> Issue Type: Bug
> Components: query-criteria, query-hql
> Affects Versions: 3.3.1
> Environment: Microsoft SQL server 2005, Hibernate 3.3.1
> Reporter: sathish
> Assignee: Sharath Reddy
> Attachments: hibernate-3.5.0-beta-3-annotations.patch, hibernate-3.5.0-beta-3-core.patch, trace.txt
>
>
> When i try to join 2 entities by OneToOne using a Non-primary key column, it throws the following exception:
> org.hibernate.PropertyAccessException: could not get a field value by reflection getter of com.xxx.domain.Inventory.sku
> Caused by: java.lang.IllegalArgumentException: Can not set java.lang.String field com.inwk.estore.server.domain.Inventory.sku to java.lang.Integer
> [Full stacktrace attached]
> sku is the Non-primary key String join column by which im trying to do a OneToOne join between Item and Inventory entity.
> Apparently its trying to interpret Sku as an Integer column. Adding columnDefinition as VARCHAR/String doesn't help either
> Mappings for Item and Inventory are below:
> class Item{
> @Id
> Long id;
> @Column
> String sku;
> //some more properties
> @OneToOne(optional = true)
> @JoinColumn(name = "sku", referencedColumnName = "sku", insertable = false, updatable = false)
> Inventory inventory;
> }
> class Inventory{
> @Id
> Long id
> @Column
> String sku
> @Column
> Long quantity;
> }
--
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