[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4281) @ManyToMany appears to ALWAYS generate a left outer join SQL

[Jari Juslin (JIRA)]

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

Jari Juslin commented on HHH-4281:
----------------------------------

The worst thing is, because of the join, the children are always retrieved from DB, even when they are already in cache..

> @ManyToMany appears to ALWAYS generate a left outer join SQL
> ------------------------------------------------------------
>
>                 Key: HHH-4281
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4281
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: annotations
>            Reporter: Barry Davies
>            Priority: Minor
>         Attachments: files.zip
>
>
> A collection mapping created using the @ManyToMany JPA annotation appears to create a left outer join SQL regardless of whether the joinColumn or inverseJoinColumn are marked nullable or not.  This might be in error.  Emmanuel asked for a JIRA issue to be created, so here we are.  I have attached some files that can recreate what I believe to be the issue.  
> The forum topic where this was brought up is:
> http://forum.hibernate.org/viewtopic.php?t=977936

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