[hibernate-issues] [Hibernate-JIRA] Issue Comment Edited: (HHH-1673) hql parsed with exception (with clause)

[Erik (JIRA)]

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

Erik edited comment on HHH-1673 at 12/29/11 3:29 AM:
-----------------------------------------------------

The remark of Yves-Marie Lainé triggered me to apply this patch as well. It took me some time to figure it out for hibernate tools. So I like to share the recipe.
Hibernate3.jar:
- applied the patch (see attachments above) to hibernate 3.6.9 {{org.hibernate.hql.ast.HqlSqlWalker.java}} 
- replaced the classes {{HqlSqlWalker.class}} and {{HqlSqlWalker$WithClauseVisitor.class}} in my {{hibernate3.jar}}

HibernateTools in eclipse Indigo SR1:
- applied it to {{.../plugins/plugins/org.jboss.tools.hibernate4_0_3.4.0.v20111221-0406-H613-Beta1/lib/required/hibernate-core-4.0.0.CR6.jar}} ({{org.hibernate.hql.internal.ast.HqlSqlWalker.java}})
- I did not had the sources at hand so I patched the two generated class files in {{hibernate-core-4.0.0.CR6.jar}} the at path {{org/hibernate/hql/internal/ast/}}. 
Up to know I did not experienced any issues with this approach, but there is to some extend a risk.

      was (Author: eremmel):
    The remark of Yves-Marie Lainé triggered me to apply this patch as well. It took me some time to figure it out for hibernate tools. So I like to share the recipe.
Hibernate3.jar:
- applied the patch (see attachments above) to hibernate 3.6.9 {{org.hibernate.hql.ast.HqlSqlWalker.java}} 
- replaced the classes {{HqlSqlWalker.class}} and {{HqlSqlWalker$WithClauseVisitor.class}} in my {{hibernate3.jar}}
HibernateTools in eclipse Indigo SR1:
- applied it to {{.../plugins/plugins/org.jboss.tools.hibernate4_0_3.4.0.v20111221-0406-H613-Beta1/lib/required/hibernate-core-4.0.0.CR6.jar}} ({{org.hibernate.hql.internal.ast.HqlSqlWalker.java}})
- I did not had the sources at hand so I patched the two generated class files in {{hibernate-core-4.0.0.CR6.jar}} the at path {{org/hibernate/hql/internal/ast/}}. 
Up to know I did not experienced any issues with this approach, but there is to some extend a risk.
  
> hql parsed with exception (with clause)
> ---------------------------------------
>
>                 Key: HHH-1673
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1673
>             Project: Hibernate Core
>          Issue Type: Deprecation
>          Components: query-hql
>    Affects Versions: 3.1.3, 3.5.3
>            Reporter: Tomasz Bech
>         Attachments: HHH-1673.patch, HHH-1673.patch
>
>
> The 'improvement' bug fix: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1520
> has broken working functionality:
>  I found that after switching to 3.1.3 following construction is not working any longer:
> (FootnoteTypeBO has collection 'descriptions' and reference to languageBO)
> from FootnoteTypeBO as o
> left outer join o.descriptions as t1
> with (t1.language in (select loid from LanguageBO where name = 'aa'))
> --> exception: 'with-clause referenced two different from-clause elements'.
> There is no implicit join as dewscribed in main anomaly, so it shouldn't cause the problem. So now there is no way to write correct hql/sql, and I don't see any workaround.

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