[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-16) Explicit joins on unrelated classes

[Douglas Ferguson (JIRA)]

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

Douglas Ferguson commented on HHH-16:
-------------------------------------

Without a major refactor, I am stuck using the Criteria API. Can someone suggest a workaround or point me in the right direct as far as how to patch hibernate. I.E. Where does hibernate actually generate the html?

I can't really think of another way of doing this in SQL, or is there a way to include HQL or SQL inside of Criteria? I've seen the sql projection, but this wouldn't work for creating the join...

> Explicit joins on unrelated classes
> -----------------------------------
>
>                 Key: HHH-16
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-16
>             Project: Hibernate Core
>          Issue Type: New Feature
>          Components: core
>    Affects Versions: antlr-rework
>         Environment: Any
>            Reporter: David Lloyd
>            Assignee: Steve Ebersole
>             Fix For: antlr-rework
>
>
> It would be nice to be able to do explicit joins on unrelated classes with HQL:
> (hope this renders correctly)
>           select empl, phone
>             from org.example.Employee empl
>  left outer join org.example.PhoneBook phone
>               on phone.lastName = empl.lastName
>              and phone.firstName = empl.firstName
>            where empl.salaryGrade > 10
> Note that this would also implicity solve HB-1089 because you could list join criteria that match what Hibernate would have chosen anyway (i.e., list a many-to-one relationship as a criteria explicitly).
> Syntactically this could be disambiguated from the existing join syntax because the token after "join" is a class name rather than a property name.

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