[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-1079) Named parameter does not appear in Query using UNION

Steve Ebersole (JIRA) noreply at atlassian.com
Mon Mar 21 13:01:15 EDT 2011


     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1079?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Ebersole closed HHH-1079.
-------------------------------


Closing stale resolved issues

> Named parameter does not appear in Query using UNION
> ----------------------------------------------------
>
>                 Key: HHH-1079
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1079
>             Project: Hibernate Core
>          Issue Type: Bug
>    Affects Versions: 3.1 rc 1
>         Environment: Hibernate 3.1rc1
> Hibernate Annotation 3.1 Beta 6
> Firebird 1.5.2
>            Reporter: Leandro Sinhorini Alves
>            Assignee: Steve Ebersole
>
> My HQL throws "org.hibernate.QueryException: Named parameter does not appear in Query: operacaoRC"
> But, how can you see, the parameter operacaoRC is in the second query of union.
> select ept.medidaQuantidade, ept.produto.nome, ept.empresa.nome, ept.ccEmprestimoDestino.empresa.nome 
>    from br.com.b2brasil.centralfacil.dw.financeiro.Emprestimo ept 
> where ept.dataMovimento = :data 
>    and ept.operacao = :operacaoEC 
>    and ept.produto.produtoNivel2.id = :produtoId 
> union 
> select ept.medidaQuantidade, ept.produto.nome, ept.ccEmprestimoOrigem.empresa.nome, ept.empresa.nome 
>    from br.com.b2brasil.centralfacil.dw.financeiro.Emprestimo ept 
>  where ept.dataMovimento = :data 
>     and ept.operacao = :operacaoRC 
>    and ept.produto.produtoNivel2.id = :produtoId

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

        


More information about the hibernate-issues mailing list