[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-7307) referencedColumnName is being ignored for OneToOne mapping

[Sanne Grinovero (JIRA)]

    [ https://hibernate.onjira.com/browse/HHH-7307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=46565#comment-46565 ] 

Sanne Grinovero commented on HHH-7307:
--------------------------------------

Hi farhad,
thanks for the report but Hibernate Search wasn't the correct project. I've moved it to Hibernate ORM.

> referencedColumnName is being ignored for OneToOne mapping
> ----------------------------------------------------------
>
>                 Key: HHH-7307
>                 URL: https://hibernate.onjira.com/browse/HHH-7307
>             Project: Hibernate ORM
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 4.1.2
>            Reporter: farhad ch
>            Priority: Critical
>
> Using a soft key instead of FK is necessary for legacy DB's and currently 4.1.2 has issues with this.  I am using:
>    
>  @OneToOne(fetch = FetchType.LAZY)
>  @NotFound(action = NotFoundAction.IGNORE)
>  @JoinColumns({
>         @JoinColumn(name = "id", referencedColumnName="houseId", nullable = true, insertable = false, updatable = false)
>  })
>  public Child getChild(){
>     return this.child;
>  }
> but SQL shows join is based on PK and not Soft Key "houseId"
> @OneToOne mapping will force a FK-PK relationship and ignores values for "referencedColumnName" attributes:
> Inspecting code from AnnotationBinder and OneToOne shows few FIXME and TODO tags like:
> //FIXME referencedColumnName ignored

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira