[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5518) @ManyToOne(fetch=FetchType.LAZY) annotation generates always an inner join into a query

[Mathias Arens (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=38260#action_38260 ] 

Mathias Arens commented on HHH-5518:
------------------------------------

Hi Steve, thanks a lot. That's the trick. I just tested it. 

> @ManyToOne(fetch=FetchType.LAZY) annotation generates always an inner join into a query
> ---------------------------------------------------------------------------------------
>
>                 Key: HHH-5518
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5518
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: query-hql
>    Affects Versions: 3.5.5
>         Environment: Java 1.6.0_20, Hibernate-EntityManager 3.5.5-Final, HSQLDB, Oracle 11g
>            Reporter: Mathias Arens
>         Attachments: HibernateTest.zip
>
>
> Hibernate generates a left outer join *plus* a inner join for the same relation into my query. 
> I have a simple @ManyToOne annotation for a reference from a alert object to a user object:
> {code}
> public class Alert {
>     [...]
>     @ManyToOne(fetch = FetchType.LAZY)
>     @JoinColumn(name = "RESPONSIBLE_USER_ID")
>     private UserDO responsibleUser;
>     [...]
> }
> {code}
> My jpql query is a little more complex:
> {code:sql}
> select rra from AlertWithResponsibleUserDO rra left join rra.responsibleUser, TeamDO t, BusinessPartnerSearchDO bps join t.teamMembers tm where rra.businessPartnerId = bps.businessPartnerId and (bps.ratingObjectType = 'STANDARD' or bps.ratingObjectType is null) and bps.analyst = tm.organisationalUnit and t.id = :teamId and rra.severity in (:severities) and bps.locale = :locale and bps.localeBpType = :localeBpType"
> {code}
> The central outer join definition is this:
> {code}
> AlertWithResponsibleUserDO rra left join rra.responsibleUser
> {code}
> But Hibernate keeps creating a left outer join *and* a inner join for this relation whatever I do:
> {code:sql}
> from
>         V440_R_ALERTS_WITH_RESP_USER alertwithr0_ 
>     left outer join
>         V004_USER userdo1_ 
>             on alertwithr0_.F440_F004_RESPONSIBLE_USER_ID=userdo1_.F004_ID 
>     inner join
>         V004_USER userdo6_ 
>             on alertwithr0_.F440_F004_RESPONSIBLE_USER_ID=userdo6_.F004_ID cross 
> {code}
> I already tried different queries and @ManyToOne attributes but none of them affected the sql outcome. I tried a similar relation in a different context but there it worked. Hibernate generated only a left outer join into the sql query. But I don't know which settings generate the two joins on the same relation.
> I have added a simple maven test project. Just unzip the HibernateTest.zip and run 'mvn test'. A starting point for further testing could be the AppTest.testManyToOneInnerJoinIssue() test routine.
> Thanks for your help in advance.

-- 
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